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 |