AVERAGE function
Average sample daily consumption.
Statistical
Where can you use it?
Analytics, quality and research teams. Use this group to examine distributions, variability or relationships in measurements, sales or service durations.
Scenario in the workbook
Calculate an arithmetic mean. A zero amount is a real observation and contributes to the denominator.
A worked example from the workbook
| Row | A | B | C |
|---|---|---|---|
| 6 | Region | Status | Amount |
| 7 | North | Paid | 120 |
| 8 | South | Paid | 75 |
| 9 | North | Open | 40 |
| 10 | North | Paid | 80 |
| 11 | South | Open | 0 |
All transactions
=AVERAGE(C7:C11)Expected result63
See the inputs and instructions for all 3 examplesSyntax
AVERAGE(number1, [number2], …)
Copyable formulas
English Excel · en-US
=AVERAGE(6,8,10)Turkish Excel · tr-TR
=ORTALAMA(6;8;10)Example and expected result
Calculate the arithmetic mean of three daily usage figures. Zeros in a referenced range are included.
Expected result 8.
Worked examples
Calculate an arithmetic mean. A zero amount is a real observation and contributes to the denominator.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B | C |
|---|---|---|---|
| 6 | Region | Status | Amount |
| 7 | North | Paid | 120 |
| 8 | South | Paid | 75 |
| 9 | North | Open | 40 |
| 10 | North | Paid | 80 |
| 11 | South | Open | 0 |
| Case | Formula | Expected result |
|---|---|---|
| All transactions | =AVERAGE(C7:C11) |
63 |
| First two transactions | =AVERAGE(C7:C8) |
97.5 |
| Including zero | =AVERAGE(C10:C11) |
40 |