Summing Fields with Multiple Criteria

[bpliskow]

I have a spreadsheet with the following values:

A B
01-JAN-06 John Smith
01-JAN-06 Jane Doe
01-FEB-06 John Smith
09-FEB-06 John Smith
etc.

Either in the same or new worksheet, I want to calculate the number of
times "John Smith" and "JAN" appear in the same row, "Jane Doe" and
"JAN", "John Smith" and "FEB", etc.

The expected results would appear as follows:

January
John Smith 1
Jane Doe 1

February
John Smith 2
Jane Doe 0

What is the formula needed to accomplish this?

 

[vezerid]

=SUMPRODUCT(IF(TEXT(A1:A100,"Mmmm")="January",1,0),IF(B1:B100="John
Smith,1,0))

HTH
Kostis Vezerides