Adding sales by year & month by customer.

G

gacollege

Hey everyone,

I am looking for a formula that will take the sum the values of sales
by customer in the spreadsheet attached. I am needing column F in the
'result' tab to total the sales dollars by customer, by month, by year.


I have placed a 'data' tab showing how the data is dumped and I have
inserted a 'result' tab that shows what I am looking for. The original
data tab is 23,000 rows.

Any help would be greatly appreciated!!!


Richard

File Attached: http://www.exceltip.com/forum/attachment.php?postid=314783 (question2.xls)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting sales by month, by year 2
Lookup matching 3 values to 3 others and returning a value 4
Extracting data from database into separate sheets 0
Calulate Sales for Previous Year 4
Sum multiple worksheet sales data by month 4
Sum with multiple conditions 6
Present Value Uneven Cashflows 6
Need help with average/lookup formula 2

Top