ExcelBanter - Sumproduct Formula to counts multiple criteria in two columns?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumproduct Formula to counts multiple criteria in two columns? (https://www.excelbanter.com/excel-worksheet-functions/210877-sumproduct-formula-counts-multiple-criteria-two-columns.html)

EricB

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

Bob Phillips[_3_]

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

All times are GMT +1. The time now is 07:27 PM.