Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells that matches multiple criteria in Excel?
I have a worksheet with product code in column A, Salesperson in column B and
Sales Location in column C. I want to count the number of rows that fit my criteria; i.e. I want to count the number of rows that are product code 1 AND sales location 5. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells that matches multiple criteria in Excel?
=SUMPRODUCT((A1:A1000=1)*(C1:C1000=5))
SUMPRODUCT has to have a range defined rther than whole columns. "MEAD5432" wrote: I have a worksheet with product code in column A, Salesperson in column B and Sales Location in column C. I want to count the number of rows that fit my criteria; i.e. I want to count the number of rows that are product code 1 AND sales location 5. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells that matches multiple criteria in Excel?
=SUMPRODUCT(--(A2:A20=1),--(B2:B20=5))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MEAD5432" wrote in message ... I have a worksheet with product code in column A, Salesperson in column B and Sales Location in column C. I want to count the number of rows that fit my criteria; i.e. I want to count the number of rows that are product code 1 AND sales location 5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count cells using multiple criteria | Excel Worksheet Functions | |||
how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
how do I count pairs of cells when each matches a condition? | Excel Discussion (Misc queries) | |||
Count nonblank cells with multiple criteria | Excel Worksheet Functions | |||
count cells using multiple criteria | Excel Discussion (Misc queries) |