Using COUNTIF with multiple lookup

[cruizectrl]

I'm stuck on making a report page for our workbook to track our telemarketing per week. I have one page per week (52 workbooks) I able to use the COUNTIF statement for one column...

A
John
John
Andy
Andy
Sue


Totals
John "=COUNTIF(A2:A99,"John&quot"
2
Andy "=COUNTIF(A2:A99,"Andy&quot"
2
Sue "=COUNTIF(A2:A99,"Sue&quot"
1

Now at the end of the report I need to check in an extra column so now taking the example above I ad in another column counting if a sale is made or not.

A B
John Reject
John Sale
Andy Sale
Andy Reject
Sue Sale

Everytime I try to put in the extra argument with the count if statement it returns an error. The formula so far looks somthing like this.

=COUNTIF(Wk52!A299,Wk52!A22)

 

[susejdrol]

I think this is the same basic question that has been coming up on the forum for a while. I think I may have been the first to ask it in the recent past.

Anyhow, the solution that we came to was:

=sumproduct((Wk52!$A:$A="John&quot*(Wk52!$B:$B="Sale&quot)

if you are trying to count sales.

Hope this helps

CP