Sum table values based on condition

[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

 

[Mike]

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+D220))
or Have E1=Tue and use the formula below
=SUMPRODUCT(--(A2:A20=E1),(B2:B20+C2:C20+D220))

 

[Eduardo]

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