Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum table values based on condition
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum table values based on condition
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)) "SCC" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum table values based on condition
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 "SCC" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
How to average values based on a condition in another column | Excel Worksheet Functions | |||
Populating a table based on values in another table | Excel Worksheet Functions | |||
assigning value to a column based on a table of values | Excel Discussion (Misc queries) | |||
Cannot sum values based on condition | Excel Worksheet Functions |