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
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

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!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,809
Messages
5,544,419
Members
410,610
Latest member
renatha prado
Top