summing totals from codes

[jspinx]

Thanks everyone for your help yesterday, the solution worked like a charm.

I am stuck yet again today. The attached spreadsheet has dollar amounts associated with codes. At the bottom are the codes all listed in a column. I would like the totals of each of the codes to automatically appear. What is the simplest formula for this?

As you can see the total for code 6850 should be $1,300

[BigBas]

Based on these assumption:

Codes are in column A
Prices are in Column B
Codes list (where you want to sum unique codes) is in column C

Enter this formula in D1 and fill down:

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

Let me know if that works.

[jspinx]

thanks for the fast response, but it didnt work, i posted the actual spreadsheet here. I appreciate you helping me out

[jspinx]

sorry, file size was too big, i had to reduce it, its attached

[jspinx]

found it, i actually found the problem, i was referencing the wrong column (its friday). thanks