| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using COUNTIF with AND
This should be pretty easy; it's a little embarrasing to ask. I'm
trying to count all cells with a value within a specified range. It's not working. Here is the formula I'm using: =COUNTIF(A1:A17,(AND(A1:A173,A1:A17<6))) Where am I going wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using COUNTIF with AND
Try it this way:
=COUNTIF(A1:A17,"<6") - COUNTIF(A1:A17,"<3") Hope this helps. Pete On Jul 3, 4:15*pm, wrote: This should be pretty easy; it's a little embarrasing to ask. I'm trying to count all cells with a value within a specified range. It's not working. Here is the formula I'm using: =COUNTIF(A1:A17,(AND(A1:A173,A1:A17<6))) Where am I going wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using COUNTIF with AND
Sorry,
strictly speaking it should be: =COUNTIF(A1:A17,"<6") - COUNTIF(A1:A17,"<=3") Pete On Jul 3, 4:20*pm, Pete_UK wrote: Try it this way: =COUNTIF(A1:A17,"<6") - COUNTIF(A1:A17,"<3") Hope this helps. Pete On Jul 3, 4:15*pm, wrote: This should be pretty easy; it's a little embarrasing to ask. I'm trying to count all cells with a value within a specified range. It's not working. Here is the formula I'm using: =COUNTIF(A1:A17,(AND(A1:A173,A1:A17<6))) Where am I going wrong?- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using COUNTIF with AND
On Jul 3, 9:15*am, wrote:
This should be pretty easy; it's a little embarrasing to ask. I'm trying to count all cells with a value within a specified range. It's not working. Here is the formula I'm using: =COUNTIF(A1:A17,(AND(A1:A173,A1:A17<6))) Where am I going wrong? That takes care of it. Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using COUNTIF with AND
Hi
You could also use this: =SUMPRODUCT((A1:A173)*1,(A1:A17<6)*1) Regards, Per skrev i meddelelsen ... On Jul 3, 9:15 am, wrote: This should be pretty easy; it's a little embarrasing to ask. I'm trying to count all cells with a value within a specified range. It's not working. Here is the formula I'm using: =COUNTIF(A1:A17,(AND(A1:A173,A1:A17<6))) Where am I going wrong? That takes care of it. Thanks! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using COUNTIF with AND
You're welcome, Linda - thanks for feeding back.
Pete On Jul 3, 4:24*pm, wrote: That takes care of it. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| countif | Excel Discussion (Misc queries) | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Hybrid Mode
