Syntax
AVG(value1, [value2, ...])
| Parameter | Description |
|---|---|
| value1 | Parameter of the AVG function. |
| [value2 | (Optional.) Parameter of the AVG function. |
| ...] | Parameter of the AVG function. |
Examples
Average monthly revenue
Formula
=AVG(B2:B13)
Returns the mean of 12 monthly revenue values. If the values are 10000, 12000, 11000, ... it sums them and divides by 12.
Average of specific cells
Formula
=AVG(A1, A5, A9)
Averages only the three specified cells, ignoring everything in between.
Average ignoring text
Formula
=AVG(C2:C100)
Returns the average of all numeric values in the range. Text and blank cells are automatically skipped.
Common Errors
#DIV/0!
Returned when the range contains no numeric values at all — for example, all cells are blank or contain text.
#VALUE!
Occurs if you pass a non-numeric argument directly, like =AVG("hello").
Tips
Blanks vs. zeros matter
AVG skips blank cells entirely, but cells containing 0 are included in the calculation. If missing data should count as zero, enter 0 explicitly.
Combine with IF for conditional averages
Use AVERAGEIF or AVERAGEIFS instead of AVG when you need to average only rows matching a condition, like averaging sales for a specific region.
Interchangeable with AVERAGE
AVG and AVERAGE are identical. Use whichever you prefer — AVG is simply shorter to type.
Try AVG in Viztab
Import your data and use AVG with 370+ other formulas. No signup required.
Open Viztab