AVERAGE Function in Excel with Example

AVERAGE ()

This function used to calculate the average from a list of numbers.

Best view in desktop mode.

	A	B	C	D	E	F	G	H	I	J	K
1		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Average
2	Temp	30	31	32	29	26	28	27	29.0	=AVERAGE(B2:H2)
3	Rain	0	0	0	4	6	3	1	2.0	=AVERAGE(B3:H3)
4
5		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Average
6	Temp	30		32	29	26	28	27	28.7	=AVG(B6:H6)
7	Rain	0		0	4	6	3	1	2.3	=AVG(B6:H6)
8
9		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Average
10	Temp	30	No	32	29	26	28	27	28.7	=AVERAGE(B10:H10)
11	Rain	0	Reading	0	4	6	3	1	2.3	=AVERAGE(B10:H10)

If the cell is blank or contains text, the cell will not be used in the average calculation.

If the cell contains zero 0, the cell will be included in the average calculation.

Syntax

=AVERAGE (Range1, Range2, Range3... through to Range30)

=AVG (Range1, Range2, Range3... through to Range30)

Formatting

No special formatting is needed.

For example

To calculate the average of cells which contain text or blanks use =SUM() to get the total and then divide by the count of the entries using =COUNTA().

	A	B	C	D	E	F	G	H	I	J	K
1		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Average
2	Temp	30	No	32	29	26	28	27	24.6	=SUM(D31:J31)/COUNTA(D31:J31)
3	Rain	0	Reading	0	4	6	3	1	2	=SUM(D32:J32)/COUNTA(D32:J32)
4
5		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Average
6	Temp	30		32	29	26	28	27	28.7	=SUM(D35:J35)/COUNTA(D35:J35)
7	Rain	0		0	4	6	3	1	2.3	=SUM(D36:J36)/COUNTA(D36:J36)

MAX in Excel

<<  Previous

Next  >>

SUM in Excel