greater than and equal to formulas
 

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.

greater than and equal to formulas
 

Melanie,

Try this

=COUNTIF(F2:I8,"=1")-COUNTIF(F2:I8,"6")

Mike

"Melanie" wrote:

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.

greater than and equal to formulas
 

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

"Mike H" wrote:

Melanie,

Try this

=COUNTIF(F2:I8,"=1")-COUNTIF(F2:I8,"6")

Mike

"Melanie" wrote:

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.

greater than and equal to formulas
 

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

"Melanie" wrote:

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

"Mike H" wrote:

Melanie,

Try this

=COUNTIF(F2:I8,"=1")-COUNTIF(F2:I8,"6")

Mike

"Melanie" wrote:

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.