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.
--
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.
--
Mike
Hi Mike,
One way would be to use SumProduct()
=SUMPRODUCT(--(A1:A10="Y"),--(B1:B10=2))
Regards,
Bondi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks