View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DaiABolical
 
Posts: n/a
Default 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