Average in Excel

Average in Excel

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.

Microsoft Excel Function

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

                                                                                                                                     

                            

			Mon	Tue	Wed	Thu	Fri	Sat	Sun	Average
		Temp	30	31	23	29	32	28	27	28.571	=AVERAGE(D4:J4)
		Rain	0	0	7	4	6	3	1	3	=AVERAGE(D5:J5)

                                                         

                                                                                                         

                                                                                                                                     

          

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.57142857        =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.66666667        =SUM(D35:J35)/COUNTA(D35:J35)                    

                   Rain   0                 0        4        6        3        1        2.333333333        =SUM(D36:J36)/COUNTA(D36:J36)