CountIF Two text varibles

markwight · Sep 20, 2006

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 · Sep 20, 2006

Does this work for you?

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

Scott Huish · Sep 20, 2006

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

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

markwight · Sep 20, 2006

It works but..

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

Scott Huish · Sep 20, 2006

Can you be a little more specific?