LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JCowell
 
Posts: n/a
Default Sum like items

I have a report that keeps track of:
Product #, Customer #, Qty Sold for every invoice on a specific date

I want to add/SUM all the (Qty Sold) for all Like (Product #'s) regardless
who they were purchased by. To give me my total units sold.

And also be able to SUM the (Qty Sold) for each specific Customer. To give
me that Customers Total Useage.


 
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
Pivot Table - untick all items in row field DD1 Excel Discussion (Misc queries) 6 May 3rd 06 07:17 PM
How to group multiple items in to three groups. ramana Excel Worksheet Functions 4 December 1st 05 06:12 AM
Pivot Table: How can I organize data items in a row? [email protected] Excel Discussion (Misc queries) 2 October 7th 05 07:55 PM
multiple items in database Peter Excel Worksheet Functions 2 June 15th 05 08:19 PM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM


All times are GMT +1. The time now is 09:39 PM.

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"