Arial * |
10 - 80^ | ||||

- Jfc 2 = 1 | |||||

A |
B |
c |
D |
E | |

1 | |||||

Salesperson |
Units |
Price per Unit |
Revenue | ||

Rob Wittmaack |
10 |
5 |
50 | ||

Derek Smith |
23 |
5.45 |
125.35 | ||

Scott Douglass |
105 |
6 |
630 | ||

Glare Dodds |
65 |
5.75 |
373.75 | ||

Tom Denning |
42 |
6 |
252 | ||

Darren Gratton |
12 |
5 |
60 | ||

Steve Grigg |
65 |
5 |
325 | ||

Avi Abadi |
35 |
6 |
280 | ||

Nick Harvey |
34 |
3.5 |
119 | ||

Rob Last |
26 |
5.9 |
153.4 | ||

Jo Penny |
12 |
8.4 |
100.8 | ||

Rachael Unsworth |
10 |
2.6 |
26 | ||

Kim Holtham |
36 |
3.4 |
122.4 | ||

Tim Weeks |
34 |
5.9 |
200.6 | ||

Matt Bailey |
21 |
5.3 |
111.3 | ||

Steve Hawkins |
24 |
2.9 |
69.6 | ||

Damian Hughes |
29 |
7.8 |
226.2 | ||

Calc's layout makes it easy to organize information into rows and columns. As you can see in the example, we have salespeople listed alongside the left column, customers in the second column, invoice date in the third column, and revenue in the fourth column. At the moment, no formulas are entered to help you interpret the data. Clicking the E21 cell selects it and allows you to enter in a formula in the top formula bar. If you enter in the equal sign, Calc knows that what you are entering is a formula and works accordingly.

In our example, we want to know the total revenue brought in up to now, so we need to enter in the formula =sum(E4:E20) and press Return. Calc automatically enters the result into cell E21. Now we want to see what the average order value was. To do this, we have to obtain how many orders there were. For this we can use the counta function to count the number of entries in a given list. This is usually used when you need to find out how many entries there are in a text list. So, in cell B21, enter =counta(B4:B20) and press Enter. Calc now counts the number of entries in the range and returns the total in B21. All that remains for us to do is divide the total revenue by the number of orders to find the average order value. So, in cell E22, enter the formula =E21/B21 to get the average order value.

Was this article helpful?

## Post a comment