LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default Totalling volumes per box

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
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
Automatic totalling of spend on repeated items Tommy N Excel Discussion (Misc queries) 0 November 29th 06 10:33 AM
Searching columns, summarizing, and totalling? Drew H Excel Discussion (Misc queries) 1 August 14th 06 04:55 PM
How do I sum hours and minutes totalling over 24 hours? Henry Excel Worksheet Functions 1 May 26th 06 09:11 AM
word appearance and totalling tapley Excel Discussion (Misc queries) 1 May 23rd 06 09:34 AM
Totalling Sum of Parts in a 2 column array. steev_jd Excel Discussion (Misc queries) 2 April 26th 06 03:17 PM


All times are GMT +1. The time now is 01:05 PM.

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

About Us

"It's about Microsoft Excel"