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

  • Thread starter Thread starter tel703
  • Start date Start date
T

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
 
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
 
Back
Top