I have a file with 10000 rows (one per unique product we sell). Column G has 4000 unique entries (company names). I want to get summed data (which is total sales data - sitting in Column C) for each unique company name.
How do I do that?
I have a file with 10000 rows (one per unique product we sell). Column G has 4000 unique entries (company names). I want to get summed data (which is total sales data - sitting in Column C) for each unique company name.
How do I do that?
Please take a few minutes to read the forum rules, and then edit your post to amend your thread title accordingly.
Thanks.
Entia non sunt multiplicanda sine necessitate
Content suppressed pending compliance with moderator's request.
Last edited by JBeaucaire; 10-29-2009 at 12:49 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Am I missing something here. Pls advise where to put this thread?
The problem is not where the thread is located, but with the thread title which IS NOT accurately descriptive of your question and therefore of no use to anyone who searches the forum for an answer to a similar problem.Am I missing something here. Pls advise where to put this thread?
Edit your thread title to something more descriptive, such as: Sum Values for Each Unique Company Name - or something along these lines.
Please do: read the rules - they exist for a reason.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks