PLEASE HELP - URGENT - Customer database analysis problem!

[jamesj35mm]

Hi,

New here, reasonably new to excel so apologies if I am a little unclear in my explanation of what I'm needing.

I have exported a database file that lists each individual transaction that I have processed in my shop over the past 12 months (over 10,000 rows), each transaction row lists various pieces of info in separate columns (item ref, size, invoice number, item code, customer account ID, etc...) See picture below

What I'm trying to do is have the spreadsheet show the total spend for each 'Customer ID', so I've ordered it by 'customer account ref' (which is just a number 178, 185, 192, etc...) to group all of the individual customers transactions, now I need to create a formula that will be able to give the sum of the 'Price2' column for each Customer ID.

So set the SUM range for column H based on the info in column L???

I'm really stuck. Any help would be hugely appreciated as I have over 10,500 rows of this and I don't like the idea of manually going through to select the SUM range for each customer ID.

Thanks,
James

 

[jamesj35mm]

Bump.

 

[VoG]

This may help you Outline (group) data in a worksheet - Excel - Office.com

 

[sheetspread]

Just use the subtotal feature, it inserts sum formulas (or avg, max, min, etc) at each change in value of an adjacent column.

 

[jamesj35mm]

Sweet, I'll take a look. Thanks VoG & sheetsspread.