COUNTIF >0<8

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My question is similar to the one posted by Sassy on 6/14/07 (sorry I forgot
to check which discussion group I was looking at...)

I want to find out, in the same column, the numbers that are greater than 0
but less than 8

Following the example given in response to Sassy's question, I still get the
wrong answer (there are small amounts of numbers so I can check easily)

This is the formula I tried:
=COUNTIF(O34:O45,">0")-(COUNTIF(O34:O45,"<8"))
 
You need to change the logic since you are not using AND functionality

=COUNTIF(O34:O45,">0")-(COUNTIF(O34:O45,">=8"))



this is uses AND functionality and will give the same result


=SUMPRODUCT(--(O34:O45>0),--(O34:O45<8))
 
Back
Top