=sumproduct(--(a2:a100="Salesperson 3"),--(b2:b100="Event 6"))

"dj479794" wrote:

Situation: I have the following data in cells:

A2: "Salesperson 1"
A3: "Salesperson 3"
A4: "Salesperson 5"
A5: "Salesperson 3"
A6: "Salesperson 9"
A7: "Salesperson 8"
...and so on....

B2: "Event 1"
B3: "Event 3"
B4: "Event 6"
B5: "Event 1"
B6: "Event 9"
....and so on...


If in Cell D2 I have "Salesperson 3"
And I want to find out a Count Everytime Salesperson 3 has done Event 6.
What formula do I use?

Thanks!