Discussion on:

An alternative Excel averaging formula that doesn't evaluate zero

2

Comments

Add Your Opinion

Join the conversation!

Follow via:: RSS; Email Alert

Community Preferences

View:

Please Select

Show:

Please Select

0 Votes

+ -

Good one, thanks

jonc2011 Updated - 29th Jun

Useful. In my Excel manual it include it as:
Ignore zeros when averaging

=AVERAGEIF(range," 0") also ignores empty cells

For a formula that that includes empty cells (and ignores zero cells):

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

0 Votes

+ -

Sorry

jonc2011 29th Jun

Can't get the above to include the greater/less than signs

Keyboard Shortcuts:: Prev; Next; Toggle

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.

Join Login