Sum of column C where results in column A match

D

DaiABolical

I have the following data in a worksheet

A B C
MT00926 O.HEAD MATHS DISCOVERIES SET 2 154
MT01381 GRAPHING MAT & BOOK SET 42
MT01381 GRAPHING MAT & BOOK SET 42
MT01113 LDA NUMERACY KIT YEARS 3 & 4 25
MT00925 O.HEAD MATHS DISCOVERIES SET 1 55

I need to sum the values in column C where the data in Column A i
identical.
I'm sure there is an easy way to do this but I cannot find it.

Anyone able to help?

Thanks
Davi
 
S

Stefi

Sort the sheet by column A, then create subtotals by Column A for Column C!
Regards,
Stefi


„DaiABolical†ezt írta:
 
P

Pete_UK

An alternative is to copy column A (with a heading) to a new sheet,
then apply Data | Filter | Advanced Filter to this column, choosing
Unique Records Only and Copy to another location (eg $C$1). Click OK,
then delete columns A and B.

Then enter this formula in B2:

=SUMIF(Sheet1!A$2:A$1000,A2,Sheet1!C$2:C$1000)

Adjust the ranges to suit, and copy the formula down.

Hope this helps.

Pete
 
T

Terry Gregg

DaiABolical said:
I have the following data in a worksheet

A B C
MT00926 O.HEAD MATHS DISCOVERIES SET 2 154
MT01381 GRAPHING MAT & BOOK SET 42
MT01381 GRAPHING MAT & BOOK SET 42
MT01113 LDA NUMERACY KIT YEARS 3 & 4 25
MT00925 O.HEAD MATHS DISCOVERIES SET 1 55

I need to sum the values in column C where the data in Column A is
identical.
I'm sure there is an easy way to do this but I cannot find it.

Anyone able to help?

Thanks
David
Click to expand...
Put the curser into a cell outside the range you want to add and select
Data - Consolidate. In the reference area put the range you are wanting
to add eg from your info select A1:C5. Then tick the box "use labels in
left column" this will add the like items up but you will lose the
description from column B. If you need this you can use a vlookup to
pick it up.
 
Top