Help with adding columns with variables

[NickTank]

Help. I'm trying to build a trend database that counts multiple columns. I use this formula for the first two columns:

=SUMPRODUCT(--(Jan!$A:$A="Pre-Check"),--(Jan!$B:$B="Good"))

Now I need to add another cell that can be one of 3 possible words. Column K will have "Phone", "Email", or "Business Card". How can I add to my string so that it will add the first two column combinations with any of from Column K?

Example

A B K
Pre-Check Good Phone
Pre-Check Good Email
Pre-Check Good Business Card
Pre-Check Good Email

The total should be 4.

Nick

[benishiryo]

hi Nick, welcome to the forum. you can try this:

=SUMPRODUCT((Jan!$A:$A="Pre-Check")*(Jan!$B:$B="Good")*(Jan!$K:$K={"Phone","Email","Business Card"}))

or put your criteria horizontally in somewhere say C1:E1
=SUMPRODUCT((Jan!$A:$A="Pre-Check")*(Jan!$B:$B="Good")*(Jan!$K:$K=$C$1:$E$1))

but it is not recommended you refer to the whole column A, B & K. could slow down your Excel

[NickTank]

Thanks Benishiryo. It worked great. Now to figure out what I need to do next.

Nick