software

I have the following data in a worksheet

A B C
MT00926O.HEAD MATHS DISCOVERIES SET 2154
MT01381GRAPHING MAT amp; BOOK SET 42
MT01381GRAPHING MAT amp; BOOK SET 42
MT01113LDA NUMERACY KIT YEARS 3 amp; 425
MT00925O.HEAD MATHS DISCOVERIES SET 155

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: www.excelforum.com/member.php...oamp;userid=32726
View this thread: www.excelforum.com/showthread...hreadid=525617Sort the sheet by column A, then create subtotals by Column A for Column C!
Regards,
Stefi?aiABolical??ezt ?rta:

gt;
gt; I have the following data in a worksheet
gt;
gt; A B C
gt; MT00926O.HEAD MATHS DISCOVERIES SET 2154
gt; MT01381GRAPHING MAT amp; BOOK SET 42
gt; MT01381GRAPHING MAT amp; BOOK SET 42
gt; MT01113LDA NUMERACY KIT YEARS 3 amp; 425
gt; MT00925O.HEAD MATHS DISCOVERIES SET 155
gt;
gt; I need to sum the values in column C where the data in Column A is
gt; identical.
gt; I'm sure there is an easy way to do this but I cannot find it.
gt;
gt; Anyone able to help?
gt;
gt; Thanks
gt; David
gt;
gt;
gt; --
gt; DaiABolical
gt; ------------------------------------------------------------------------
gt; DaiABolical's Profile: www.excelforum.com/member.php...oamp;userid=32726
gt; View this thread: www.excelforum.com/showthread...hreadid=525617
gt;
gt;

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