Countif
maby COUNTA
"Joeredmm" skrev:
I have a formula in a worksheet that I use to calculate the number of cells
to divide by. I use it to average percentages of the six cells which
represent monthly averages.
=SUM(H2:H7)/COUNTIF(H2:H7,"<0")
this is the formula. The problem is the formula still returns 6 even when
some of the cells contain 0.
I am using Excel 2002
--
What year did you say this was
|