I am averaging cells A1 through A20, how do I correct the formula to ignore
any cells that are blank?
I am averaging cells A1 through A20, how do I correct the formula to ignore
any cells that are blank?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks