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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
"deaundra" <[email protected]> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks