count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What would the formula be to count the number of Y's in a column if that
y cell had a number 2 in another cell in that row.
 
Hi Mike,

One way would be to use SumProduct()

=SUMPRODUCT(--(A1:A10="Y"),--(B1:B10=2))

Regards,
Bondi
 
You must log in or register to reply here.

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

Help needed urgently 3
Countif(and 7
Counting in columns 5
Counting cells in a selectable date range 0
count similar text with using filters 1
Cumlative Counting Question 4
Comparing data from two columns 2
Counting question 16

Back
Top