CountIF Two text varibles

[markwight]

I am looking to count the number of occurances where column A = BUY and column B=R. Can't seam to get countif or sumproduct to do the trick

Thanks

 

[Doug.T]

Does this work for you?

=SUMPRODUCT(((A5:A11)="BUY")*((B5:B11)="R"))

 

[Scott Huish]

You can't use whole columns with SUMPRODUCT, try something like this:

=SUMPRODUCT(--(A1:A1000="BUY"),--(B1:B1000="R"))

 

[markwight]

It works but..

Thanks it works, now how do I add a third column

 

[Scott Huish]

Can you be a little more specific?