by trying to figure out the complete formula u have
it looks clear u need an average function

=AVERAGE(IF((H5:H10<0),(H5:H10<0)*H5:H10))
hit ctrl-shft-enter

surely u know this especially when u want to consider a BLANK CELL as not
part of the count and has an If 0 value...data with text can be trapped since
the result will be an error - good time to fix the data..
regards
--
*****
birds of the same feather flock together..



"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.