greater than and equal to formulas

M

Melanie

Hi, I am trying to use a >=1 and <=6 function for a range in my worksheet. I
have tried this and it is not working. =COUNTIF(F2:I8,">=1""<=6")

Any help is greatly appreciated.
 
M

Melanie

Hi Mike,

That worked. Now to see if I can pick your brain again. I actually want to
have that same formula but with multiple ranges that are separated by a few
rows. The next range would be F18:I26. Do you know how I can do that?

Thanks,

Melanie
 
M

Mike H

Hi,

The most obvious answer is this

=COUNTIF(F2:I8,">=1")-COUNTIF(F2:I8,">6")+COUNTIF(F18:I26,">=1")-COUNTIF(F18:I26,">6")

but it now starts getting messy

Mike
 
Top