View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brantty brantty is offline
external usenet poster
 
Posts: 16
Default Need formula to add cells with same group

I have a sheet 1 with two columns. Column A has a manufacturer name, Column
B has a number. Column A has the manufacturer names repeated multiple times
within the column. Sheet 2, Coumn A, I have a clean list of manfufacturers
that match the cells in Sheet1 Column A. In sheet 2, Coulmn B, I need a
formula that will add all the numbers for each manufacturer. So, if Hp shows
up 15 times in column A, the formula will add only those numbers that match
column A and produce the total of the numbers added together for that
manufacturer.

Ex. Sheet 1: Column A, Column B

HP, 5.50
HP, 5.75
DF, 5.00
DF, 4.25

Sheet 2: end result Im looking for:
HP, 11.25
DF, 9.25