Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a large spreadsheet that has four columns. Whta this spreadsheet is
contains the number of customers in each area and each breakdown of the hour. What I have done is sorted by date and hour. What I would like to do is place the sum of the customers for each hour in a column. Is this possible? Customers Area Date Hour 38 01 01/01/05 3 85 02 01/01/05 3 33 03 01/01/05 3 18 04 01/01/05 3 28 05 01/01/05 3 48 06 01/01/05 3 14 07 01/01/05 3 47 08 01/01/05 3 29 09 01/01/05 3 9 22 01/01/05 3 13 23 01/01/05 3 18 24 01/01/05 3 9 25 01/01/05 3 103 01 01/01/05 4 168 02 01/01/05 4 109 03 01/01/05 4 62 04 01/01/05 4 76 05 01/01/05 4 163 06 01/01/05 4 54 07 01/01/05 4 148 08 01/01/05 4 89 09 01/01/05 4 29 22 01/01/05 4 58 23 01/01/05 4 57 24 01/01/05 4 24 25 01/01/05 4 73 01 01/01/05 5 144 02 01/01/05 5 80 03 01/01/05 5 55 04 01/01/05 5 62 05 01/01/05 5 130 06 01/01/05 5 Date 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 1:00 2:00 3:00 4:00 03/20/05 227 669 502 527 714 1105 1450 1747 2141 2265 2563 2648 2730 2729 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Rows and columns | New Users to Excel |