.

AVERAGE EXCEL FORMULA

EXCEL FORMULA
Function Dictionary Function Examples Function Categories

AVERAGE

               
 
 
Mon Tue Wed Thu Fri Sat Sun Average
Temp 30 31 32 29 26 28 27 29  =AVERAGE(D4:J4)
Rain 0 0 0 4 6 3 1 2  =AVERAGE(D5:J5)
Mon Tue Wed Thu Fri Sat Sun Average
Temp 30   32 29 26 28 27 28.667  =AVERAGE(D8:J8)
Rain 0   0 4 6 3 1 2.3333  =AVERAGE(D9:J9)
Mon Tue Wed Thu Fri Sat Sun Average
Temp 30 No 32 29 26 28 27 28.667  =AVERAGE(D12:J12)
Rain 0 Reading 0 4 6 3 1 2.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().
Mon Tue Wed Thu Fri Sat Sun Average
Temp 30 No 32 29 26 28 27 24.571  =SUM(D31:J31)/COUNTA(D31:J31)
Rain 0 Reading 0 4 6 3 1 2  =SUM(D32:J32)/COUNTA(D32:J32)
Mon Tue Wed Thu Fri Sat Sun Average
Temp 30   32 29 26 28 27 28.667  =SUM(D35:J35)/COUNTA(D35:J35)
Rain 0   0 4 6 3 1 2.3333  =SUM(D36:J36)/COUNTA(D36:J36)
Further Usage

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download