ExcelBanter - disregarding empty fields during average

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

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

- - disregarding empty fields during average (https://www.excelbanter.com/excel-discussion-misc-queries/38511-disregarding-empty-fields-during-average.html)

Todd Nelson

disregarding empty fields during average

What formula can I use that will disregard the fields that are either blank
or "0" when averaging a block of cells?

Eric

Todd,

Try:

=SUMIF(range,"0")/COUNTIF(range,"0")

where "range" is, of course, the range you actually want to average.

Eric

"Todd Nelson" wrote:

What formula can I use that will disregard the fields that are either blank
or "0" when averaging a block of cells?

All times are GMT +1. The time now is 07:01 AM.