COUNTIF with 2 seperate events

[DeCaelo]

I have 2 columns with numbers in A and names in B.

1 DAVE
2 STEVE
3 MIKE
1 DAVE
2 FRED
4 Steve

What's the best way to go about finding how many times Dave appears with a 1?

 

[jeffreybrown]

How about a pivot table?

If not

2007 =COUNTIFS($A$1:$A$6,1,$B$1:$B$6,"Dave")

Pre-2007 =SUMPRODUCT(--($A$1:$A$6=1),--($B$1:$B$6="Dave"))

Instead of hard coding you could also point to a cell.

=COUNTIFS($A$1:$A$6,G1,$B$1:$B$6,H1)
=SUMPRODUCT(--($A$1:$A$6=G1),--($B$1:$B$6=H1))

 

[DeCaelo]

SUMPRODUCT works perfectly.

Cheers dude

 

[jeffreybrown]

You're welcome