Determine a result of one column based on conditions in two column
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
"tel703" wrote:
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
|