Auto Calculate list

[rae30]

Here's a question for all you Excel Guru's...

I would like my spreadsheet to automatically add a line and sum a range.

I recieve a very large spreadsheet every month (15000 lines) with a list of all our invoices by client, I then have to go and sum up what each client owes. Some clients have only 1 invoice where as others have over 50. This takes me way too long to do, is there an easier way?


Thanks for your assistance

 

[Brian from Maui]

First thoughts would be a Pivot Table or SUMIF. Care to post some sample data and expected results?

 

[orysiar]

With your excel file opened, make sure that all of your company names or any other unique identifier to a specific company are the same. For example, if you have Company A, Co. a and company A - make sure they all appear the same.

Then go to Data -> Subtotals -> and then choose the header in your excel file that is unique (in this example, I am using company name). Then choose what mathematical calc you want performed (in this case sum) and then choose which columns you want the calculations to be performed on. Unfortunately, it cannot do 2 different mathematical calculations in one line.

Voila!