Help with ignoring blank cells

D

Darren

I am averaging cells A1 through A20, how do I correct the formula to ignore
any cells that are blank?
 
R

Ron Coderre

If you are using the AVERAGE function, it already ignores blanks:

=AVERAGE(A1:A20)

Are you using another method for calculatiing the average?


***********
Regards,
Ron
 
Top