Try...

=SUMPRODUCT(--(B1:B100="Barry"),--(G1:G100="Y"))

Hope this helps!

In article ,
"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?