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. |
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. |
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. |
All times are GMT +1. The time now is 06:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com