Sum of column C where results in column A match
 

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


--
DaiABolical
------------------------------------------------------------------------
DaiABolical's Profile: http://www.excelforum.com/member.php...o&userid=32726
View this thread: http://www.excelforum.com/showthread...hreadid=525617

Sum of column C where results in column A match
 

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


€žDaiABolical€� ezt Ã*rta:


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


--
DaiABolical
------------------------------------------------------------------------
DaiABolical's Profile: http://www.excelforum.com/member.php...o&userid=32726
View this thread: http://www.excelforum.com/showthread...hreadid=525617

Sum of column C where results in column A match
 

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