Formula Assistance

[John]

I have a spreadsheet with containing two columns of numbers. The first
column has numbers that represent task or job numbers. It is certain
that the task or job numbers will be repeated throughout the column.
Beside this column will be associated dollar amounts. I need a formula
that will look at the first column and add up the dollar amounts for the
task or job numbers that are the same and then list all of the unique
task or job numbers with the dollar values. Example

12345 $5.25
23456 $3.00
34567 $1.00
12345 $1.00
12345 $10.00
02938 $4.00
19398 $7.00
23456 $1.00

Resulting in:

12345 $16.25
23456 $4.00
34567 $1.00
02938 $4.00
19398 $7.00

Thanks for your help.

John

 

[John]

Sorry I posted this twice... seems my server was slow to display it.

 

[Jason Morin]

The quickest way would be to construct a pivot table. For
help on implementing this method, see:

http://www.peltiertech.com/Excel/Pivots/pivottables.htm

Your other option is to construct a list of all unique
task/job numbers and use SUMIF. For example:

=SUMIF(A:A,P1,B:B)

where col. A contains tasks, col. B contains dollars, and
P1 is the first task no. Then just copy the formula down.

HTH
Jason
Atlanta, GA

 

[...Patrick]

Hi,
if possible use pivot table or sort in A column and make a sub total ...


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel