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
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