count

M

Mike

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.
 
B

Bondi

Hi Mike,

One way would be to use SumProduct()

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

Regards,
Bondi
 
Top