The purpose of the post is that I was not thinking. Yes, the answer is
obvious.

Sorry about this.
--
Brevity is the soul of wit.


"pinmaster" wrote:

Hi Dave

Not sure what is the purpose of your post since you probably know the answer
but:

COUNTIF(H5:H103,"<0")

hope I passed the test :)

Regards!
Jean-Guy

"Dave F" wrote:

How would I use COUNTIF to count only those cells whose absolute values are
greater than 0?

This is my formula: =SUM(H5:H103)/COUNTIF(H5:H103,"0") But there are
negative numbers in the range which should be counted as well as the positive
numbers. I only want to exclude 0 values.

Thanks,

Dave
--
Brevity is the soul of wit.