How to Count only Positive values in a given range

Count only Positive values in a given range

Count only Positive values in a given range

Count only Positive values in a given range
=countif(Data-Range,”>0″)

This trick is useful when you need to calculate average of a bunch of numbers but need to exclude zeros and negative values:
=sum(Data-Range)/countif(Data-Range,”>0″)

When you need to calculate average of numbers but need to exclude zeros only
=sum(Data-Range)/countif(Data-Range,”<>0″)

Show Comments

No Responses Yet

Leave a Reply