| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Formula to counts multiple criteria in two columns?
Hi
say: Column A Approved Declined Settled Column B System Smart EB FT NK I need to count "Approved" in column 'A' if data in Column 'B' = EB,FT,NK (excluding System & Smart) When using < to exclude 'System & Smart' the Sumproduct seems to count the blank cells. Regards Ericb |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct Formula to counts multiple criteria in two columns?
Just add a test
=SUMPRODUCT(--(A2:A20="Approved"),--(B2:B20<"Smart"),--(B2:B20<"System"),--(B2:B20<"")) -- __________________________________ HTH Bob "EricB" wrote in message ... Hi say: Column A Approved Declined Settled Column B System Smart EB FT NK I need to count "Approved" in column 'A' if data in Column 'B' = EB,FT,NK (excluding System & Smart) When using < to exclude 'System & Smart' the Sumproduct seems to count the blank cells. Regards Ericb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct for multiple criteria in different columns | Excel Discussion (Misc queries) | |||
| Counts for Excel 2003 using multiple criteria | Excel Worksheet Functions | |||
| sumproduct formula (multiple criteria) | Excel Discussion (Misc queries) | |||
| Need formula that Counts items matching criteria using two columns | Excel Worksheet Functions | |||
| Counts/Percents Multiple Criteria | Excel Worksheet Functions | |||
Linear Mode
