COUNT, AVERAGE, MAX AND MIN all work much like the sum function and take the same parameters. In the first example to add the values for a column of Sales. The sum function is used:
Click into the cell where you want the total (A12 in the example)
type =SUM
Press Enter for the result.
Drag over the values that you want to add (B2 to B9 in the example)
Press Enter for the result.
The COUNT function counts how many numbers are in a list of values. The following example will count the number of sales transactions.
Click into the cell where you want the count (B12 in the example)
Type =COUNT
Press Enter for the result.
Drag over the values that you want to count (B2 to B9 in the example)
Press Enter for the result.
Min and Max Functions find the Minumum and Maximum values in a list. They are both constructed the same way, in the following example I will use Max:
Click into the cell where you want to place the Maximum (C12 in the example)
Type =MAX
Press Enter for the result.
Drag over the values which you want to evauluate (B2 to B9 in the example)
Press Enter for the result.
To find the average of a list of values, use the AVERAGE Function:
Click into the cell where you want to place the Average (D12 in the example)
Type =AVERAGE
Press Enter for the result.
Drag over the values which you want to average (B2 to B9 in the example)
