COUNTIF / not SUM

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Hello,

I need a formula to do the following...In a Range (A1:Z1)
there are numbers ranging between 0-100 per cell. I need
to count(NOT SUM) any number falling between but not equal
to (0 or 100).
So if I had (A1=0, B1=80, C1=100, D1=55, E1=75, F1=0) I
need to count everything in between 0-100 so my answer
here would be 3. (B1, D1, E1 have numberics that fall
between (0-100) but are not equal to (0 or 100).

What formula satisfies this senario?

Please help
 
What's wrong with the answer I gave 2 1/2 hours ago?
=sumproduct((rngA>0)*(rngA<100))
 
YOU ARE DAN THE MAN!!!Thanks
-----Original Message-----
Maxwell,

=COUNTIF(A1:Z1, ">0") - COUNTIF(A1:Z1,">=100")

Counts the numbers >0
Subtracts those >= 100
Counts numbers in the range (0<X<100)

Dan E




.
Click to expand...
 
Sigh. They also want to know why the sky is blue.
<G>
BTW. The answer to the reasoning behind sumproduct is in the archives too.
 
Back
Top