conditional formulas
 

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?

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?

In a helper column, say X, put =b2&G2 and copy down as far as you have data
in B and G

Then in Z1 put

=countif(X:X,"BarryY")

Vaya con Dios,
Chuck, CABGx3



"deaundra" wrote in message
...
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?

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?