| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF
Can anyone tell me what I'm doing wrong in this formula?
-2 -1 0 1 2 3 4 5 6 =COUNTIF(A1:A9,"=0"&"<5") I looked at the help section and it seemed to suggest you use '&' when you have two criteria, is this where I'm going wrong? The answer should be 5, but it returns 0. I'm looking to find those numbers above zero and below five. Thanx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF
=SUMPRODUCT(--(A1:A9=0),--(A1:A9<5))
-- Gary''s Student - gsnu200756 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF
Another way is to use 2 COUNTIFs
Going by your attempt below (disregarding your description which was a little off): =COUNTIF(A1:A9,"=0"&"<5") You could also use: =COUNTIF(A1:A9,"=0")-COUNTIF(A1:A9,"=5") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "littlejess22" wrote: Can anyone tell me what I'm doing wrong in this formula? -2 -1 0 1 2 3 4 5 6 =COUNTIF(A1:A9,"=0"&"<5") I looked at the help section and it seemed to suggest you use '&' when you have two criteria, is this where I'm going wrong? The answer should be 5, but it returns 0. I'm looking to find those numbers above zero and below five. Thanx |
| 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 Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Hybrid Mode
