Sum table values based on condition

  • Thread starter Thread starter SCC
  • Start date Start date
S

SCC

How do I sum all the values based on each day. This is data for number of
computers being used in a lab. I would like to know the total number of
computers used for each day the entire semester. Thanks.

Day 7:30 AM 8:30 9:30
Mon 1 2 8
Tue 1 0 2
Wed 0 2 4
Thu 1 3 9
Mon 4 5 12
Tue 2 1 16
Wed 2 2 4
Thu 1 3 5
 
If You Days are in A2 Thru A20 And your totals are in B2 thru D20 then maybe
something like this
=SUMPRODUCT(--(A2:A20="Tue"),(B2:B20+C2:C20+D2:D20))
or Have E1=Tue and use the formula below
=SUMPRODUCT(--(A2:A20=E1),(B2:B20+C2:C20+D2:D20))
 
Hi,
try

=+SUMPRODUCT(--($E:$E=J9)*($F:$H))

Where E is the information corresponding to the day of the week, F to H are
the times and J9 is the cell where you have Mon to summarize
 
Back
Top