Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with multiple criteria
Can you use Countif for more than one Criteria? For example, I want to count
all the "complaint" in column E with a charge number of "1000568625" in column J. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with multiple criteria
No, but try it this way:
=SUMPRODUCT((E1:E1000="complaint")*(J1:J1000="1000 568625")) If you have more than 1000 rows then increase this number, but you can't have full column references unless you are using XL2007. I'm assuming that your charge number is a text value - if not, just remove the quotes. Hope this helps. Pete On Jul 1, 7:36*pm, Debbie Whitaker <Debbie wrote: Can you use Countif for more than one Criteria? *For example, I want to count all the "complaint" in column E with a charge number of "1000568625" in column J. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
Countif Multiple Criteria | Excel Discussion (Misc queries) | |||
Countif, Multiple criteria | Excel Discussion (Misc queries) | |||
COUNTIF() with multiple criteria | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |