Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Howdy All,
I have an inventory spreadsheet that contains 3 piece of pertinent info. Column A contains Box Number (i.e. 1, 2,3, etc) and there are repeat numbers Column B contains Number of Pages for given charts contained within the boxes. Column C contains Hours. Example: A1 = 1, B1 = 745, C1 = 2.5 A2 = 1, B2 = 555, C1 = 1.75 A3 = 2, B3 = 1007, C3 = 3.25 A4 = 2, B4 = 345, C4 = 0.75 I want to get the Total Number of Pages, and Total Hours, per box. So, in the example I want to know that for Box 1, I had 1300 total pages and 4.25 hours. For Box 2 I had 1352 total pages and 4.00 hours. Any ideas? Thanks, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic totalling of spend on repeated items | Excel Discussion (Misc queries) | |||
Searching columns, summarizing, and totalling? | Excel Discussion (Misc queries) | |||
How do I sum hours and minutes totalling over 24 hours? | Excel Worksheet Functions | |||
word appearance and totalling | Excel Discussion (Misc queries) | |||
Totalling Sum of Parts in a 2 column array. | Excel Discussion (Misc queries) |