Sumproduct Formula to counts multiple criteria in two columns?

E

EricB

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
 
B

Bob Phillips

Just add a test

=SUMPRODUCT(--(A2:A20="Approved"),--(B2:B20<>"Smart"),--(B2:B20<>"System"),--(B2:B20<>""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct help again 6
Count multiple cells against multiple criteria in an Excel spreads 7
Help with SUMPRODUCT 5
Sumproduct in matrix means 3
how to count rows if 2 columns partially match 5
Getting a formula to reflect added columns 10
SUMPRODUCT HELP 3
Counting cells with SUMPRODUCT and conditionals...? 1

Top