AVERAGE

Posted on 24-01-2020 , by: admin , in , 0 Comments

AVERAGE

 MonTueWedThuFriSatSunAverage 
Temp3031322926282729 =AVERAGE(D4:J4)
Rain00046312 =AVERAGE(D5:J5)
 MonTueWedThuFriSatSunAverage 
Temp30 322926282728.667 =AVERAGE(D8:J8)
Rain0 046312.3333 =AVERAGE(D9:J9)
 MonTueWedThuFriSatSunAverage 
Temp30No322926282728.667 =AVERAGE(D12:J12)
Rain0Reading046312.3333 =AVERAGE(D13:J13)

What Does It Do ?
This function calculates the average from a list of numbers.
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)

Formatting
No special formatting is needed.

Note:

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().
 MonTueWedThuFriSatSunAverage 
Temp30No322926282724.571 =SUM(D31:J31)/COUNTA(D31:J31)
Rain0Reading046312 =SUM(D32:J32)/COUNTA(D32:J32)
 MonTueWedThuFriSatSunAverage 
Temp30 322926282728.667 =SUM(D35:J35)/COUNTA(D35:J35)
Rain0 046312.3333 =SUM(D36:J36)/COUNTA(D36:J36)
share:

Leave a comment