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

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count max consecutive cells 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Vlookup Based on Multiple Conditions 4
sum up values at intervals 1
Countif across two separate columns with multiple criteria 1
Flitering for unique records in Col B based on filtering in Col A 1
Finding text in a range 5
cell returning totals of 2 cols+ sending this value to another col 5

Top