Counting I Column A says ____ And Column B says _____

  • Thread starter Thread starter umpie
  • Start date Start date
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.
 
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".
 
Back
Top