Quote Originally Posted by stanleydgromjr View Post
AGar,

Welcome to the Excel Forum.

Try in cell F1:
=SUMPRODUCT(--($D$1:$D$250="A"),--($E$1:$E$250="B"))
Hi stanley. Thanks for the quick reply, but this just didn't work out for me.

I'll try and be more clear with my situation.

I'm tracking the data from a particular game that has two parties and four randomized setups. In column B (B7:B262, to be exact) I have the setups of each particular game, labeled as A, B, C or D. In column C (C7:C262) I have the winning party of each game, labeled as M or T. What I am trying to do is search through column B and find out how many times "A" appears and then search column C for the same row values to see how many times "M" appears. I hope that makes sense.