ExcelBanter - Help with ignoring blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with ignoring blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/56343-help-ignoring-blank-cells.html)

Darren

Help with ignoring blank cells

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

Ron Coderre

Help with ignoring blank cells

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?

All times are GMT +1. The time now is 02:56 AM.