Hi Christina,

<and then add the amounts in column H

Add to what?

Did you look at VLOOKUP()?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Xina5280" wrote in message ...
|I am working on a project and trying to figure out a formula. What I want to
| have happen is in the A column I have different project codes and in the H
| column I have the cost of the task. I would like to have a formula that will
| find a specific code in column A and then add the amounts in column H so I
| would have a total sum.
|
| Thanks!
| --
| Christina