Determine a result of one column based on conditions in two column

[tel703]

Example
Col A Col B Count the number of a's in Col B only when an x is in
Col A
x a
x a Result should be 2
y a
z p I can't figure it out
x t
x m Thanks

 

[Francis]

try this


=SUMPRODUCT(--(A2:A7="x"),--(B2:B7="a"))
--
Hope this help

Please click the Yes button below if this post have helped answer your needs

Thank You

cheers, francis