This formula counts how many times the combination of Barry and Y appear in
rows 1 - 5:
=SUMPRODUCT((B1:B5="Barry")*(G1:G5="Y"))
----
Regards,
John Mansfield
http://www.pdbook.com
"deaundra" wrote:
please help!!!!!!!
Column B Column G
Barry Y
I would like to count how many times these two show together on a row. can
this be done?