Formula Help

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a spreadsheet with a column of numbers that represent tasks or
jobs. It is possible, and very likely, that the task or job numbers
will repeat themselves several times within the column. The next column
has dollar amounts. I need a formula that will list each unique task or
job number and add up the corresponding dollar amounts. Example below:
A B
12345 $1.00
32456 $2.00
12345 $1.50
45432 $3.00
56543 $3.00
12345 $5.00
32456 $1.00
02343 $10.00
12345 $0.75
32456 12.00

The formula should provide results as follows:

12345 $8.25
32456 $15.00
45432 $3.00
56543 $3.00
02343 $10.00

Thanks for all your help. I assume this is a sumproduct formula, but
I'm stuck.

John
 
One way,


select the job numbers plus their header,
do data>filter>advanced filter,
select copy to another location and unique records only,
assume you copy the list to H1 and the copied data starts in H2 (header in
H1)
now assume the original range with job numbers and amounts is A1:B200,
in I2 put

=SUMIF($A$2:$A$200,H2,$B$2:$B$200)

then copy down the formula to the last value in H
 
All of the solutions provided work great. I don't know why I didn't
think of using a pivot table in the first place. Sometimes the obvious
is sitting right there in front of you and you don't see it. Thanks to
all for their suggestions.

John
 
Back
Top