| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getpivotdata and greater than or equal to | Excel Discussion (Misc queries) | |||
| SUMIF Greater than or equal to | Excel Worksheet Functions | |||
| Greater/Less Than or Equal To | Excel Discussion (Misc queries) | |||
| IF with Equal to or Greater than | Excel Discussion (Misc queries) | |||
| Greater than or equal to (Plus or minus) | Excel Discussion (Misc queries) | |||
Hybrid Mode
