Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Using Multiple Logic Tests
I am trying to use countif to count the number of times a number greater than
3 AND less than 10 occurs in a table. I can use countif for one criteria only but cannot find a way to get it to work with more than one logic test. The following formula does not work: COUNTIF(A1:A8,"and(3,<10)") Thanks in advance, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Using Multiple Logic Tests
Use 2
=COUNTIF(A1:A8,"3")-COUNTIF(A1:A8,"=10") or sumproduct =SUMPRODUCT(--(A1:A83),--(A1:A8<10)) will return the same result -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Carl" wrote in message ... I am trying to use countif to count the number of times a number greater than 3 AND less than 10 occurs in a table. I can use countif for one criteria only but cannot find a way to get it to work with more than one logic test. The following formula does not work: COUNTIF(A1:A8,"and(3,<10)") Thanks in advance, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Using Multiple Logic Tests
Try something like this:
=SUMPRODUCT((A1:A83)*(A1:A8<10)) Does that help? *********** Regards, Ron XL2002, WinXP "Carl" wrote: I am trying to use countif to count the number of times a number greater than 3 AND less than 10 occurs in a table. I can use countif for one criteria only but cannot find a way to get it to work with more than one logic test. The following formula does not work: COUNTIF(A1:A8,"and(3,<10)") Thanks in advance, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Using Multiple Logic Tests
That solved the problem. Thanks!
"Peo Sjoblom" wrote: Use 2 =COUNTIF(A1:A8,"3")-COUNTIF(A1:A8,"=10") or sumproduct =SUMPRODUCT(--(A1:A83),--(A1:A8<10)) will return the same result -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Carl" wrote in message ... I am trying to use countif to count the number of times a number greater than 3 AND less than 10 occurs in a table. I can use countif for one criteria only but cannot find a way to get it to work with more than one logic test. The following formula does not work: COUNTIF(A1:A8,"and(3,<10)") Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using COUNTIF in multiple wooksheets | Excel Discussion (Misc queries) | |||
Countif on multiple dates | Excel Worksheet Functions | |||
How do I COUNTIF in excel using multiple criteria? | Excel Worksheet Functions | |||
COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
"countif" from multiple worksheets within workbook | Excel Discussion (Misc queries) |