Auto Calculate list

rae30

Board Regular
Joined
May 27, 2002
Messages
147
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
First thoughts would be a Pivot Table or SUMIF. Care to post some sample data and expected results?
 

orysiar

New Member
Joined
Sep 14, 2006
Messages
13
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!
 

Forum statistics

Threads
1,141,011
Messages
5,703,722
Members
421,311
Latest member
tanujath

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top