Counting I Column A says ____ And Column B says _____

U

umpie

I NEED HELP


How would I Set up a formula to do this:

In coulmn A I have a list of the days of the week, In Column E, I have
a list saying "Here" or "there"

I need to figure out a formula that will tell me that on Each day of
the week how man Mondays were "Here" and in the next cell how many were
"There."and so on through the week.
 
P

Paul

umpie said:
I NEED HELP


How would I Set up a formula to do this:

In coulmn A I have a list of the days of the week, In Column E, I have
a list saying "Here" or "there"

I need to figure out a formula that will tell me that on Each day of
the week how man Mondays were "Here" and in the next cell how many were
"There."and so on through the week.
Click to expand...

=SUMPRODUCT((A1:A100="Monday")*(E1:E100="Here"))
Adjust the ranges to suit.
Or use something like
=SUMPRODUCT((A1:A100=G1)*(E1:E100=H1))
where G1 contains "Monday" and H1 contains "Here".
 
Top