Zero Value in cells

D

Dewayne

Excel calculates zero values as part of an "average" of a
cell range. If the cell is blank it does not calculate it
in the "average"
How do I show zeros in cells and yet not have them
included in the "average" of a cell range?
Thank you in advance for the help!
Dewayne
 
F

Frank Kabel

Hi
use the following avaerage formula (entered as array formula wirh
CTRL+SHIT+ENTER):
=AVERAGE(IF(A1:A100<>0,A1:A100))
 
G

Guest

Thank you Frank. I appreciate the help!
-----Original Message-----
Hi
use the following avaerage formula (entered as array formula wirh
CTRL+SHIT+ENTER):
=AVERAGE(IF(A1:A100<>0,A1:A100))

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Average across worksheets ignoring zero 2
#DIV error 2
Average non-consecutive cells excluding zero 8
Conditional Formatting discarding zeros 1
Averaging to-date lists??? 1
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 8
Average formula where blank cells are counted as zeros 4

Top