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


"Darren" wrote:

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