LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SCC SCC is offline
external usenet poster
 
Posts: 11
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide cell values based on a condition in another cell Cat Excel Worksheet Functions 1 January 4th 07 07:21 AM
How to average values based on a condition in another column Ken99 Excel Worksheet Functions 2 November 16th 06 03:38 PM
Populating a table based on values in another table Bri Excel Worksheet Functions 0 January 26th 06 01:23 AM
assigning value to a column based on a table of values Jacob Excel Discussion (Misc queries) 3 January 13th 06 08:46 PM
Cannot sum values based on condition Ned Flanders Excel Worksheet Functions 1 December 3rd 04 04:36 AM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"