Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using countif with 2 conditions
I want to count the number of times the data in column a =913 AND the value
in column c is <=999. I only want to count rows in which both conditions are true. Countif only allows for one condition so how do I accomplish this? |
#2
|
|||
|
|||
try something like this
=sumproduct((a2:a200=913)*(c2:c200<=999)) -- Don Guillett SalesAid Software "Cheryl W" <Cheryl wrote in message ... I want to count the number of times the data in column a =913 AND the value in column c is <=999. I only want to count rows in which both conditions are true. Countif only allows for one condition so how do I accomplish this? |
#3
|
|||
|
|||
Cheryl W Wrote: I want to count the number of times the data in column a =913 AND the value in column c is <=999. I only want to count rows in which both conditions are true. Countif only allows for one condition so how do I accomplish this? Hi Cheryl Try this type this formula =SUM((A1:A15=913)*(C1:C15=999)) into any blank cell and enter as an arrayby CTRL/Shift/Enter at the same time Change the rabges A1:A15 and C1:C15 to suit your data -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=467507 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple conditions in COUNTIF (Excel 2000) | Excel Discussion (Misc queries) | |||
COUNTIF for 2 conditions | Excel Worksheet Functions | |||
countif two conditions | Excel Discussion (Misc queries) | |||
COUNTIF with two conditions | Excel Worksheet Functions | |||
How can I use COUNTIF to sum for two conditions? | Excel Worksheet Functions |