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")
=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")
0 comments:
Post a Comment