Using SUMIFS When Text Is Involved

[timsoftlayer]

Hello Forum!

I'm having a complex issue that I've tried solving with =SUMPRODUCT(SUMIFS( and regular old =SUMIFS(, but all to no avail. Here is the issue at hand:

I need to look up three criteria, one of which is a text column.

Column A - Qualifier, is this a qualified sale (yes or no)?
Column B - Salesperson, who had the sale (Jacob, Charles, etc)
Column C - Date, when did this happen (2.2.14, 2.14.14, etc)

I need these three criteria to return a sum of Column A - how many are a yes. The formula that typically works for me for such a big sum, when only numbers are involved for the summing, is:

=SUMIFS(A:A,B:B,"Salesperson name",C:C,"Coordinating date")

I've uploaded how the final product should look across. Please let me know if anything else is needed to find the best equation for this head scratcher!

[Jonmo1]

Try COUNTifs instead of SUMifs

=COUNTIFS(A:A,"Yes",B:B,"Salesperson name",C:C,"Coordinating date")