With the codes in A and the Totals in E:
=SUMIF(A1:A4,104,E1:E4)
Of course the 4 could be much higher (the row number)
You could also look at Data>Subtotals to see all the details and all the totals in one report
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| For example:
| Code Date Ticket Description Equiptment Total
|
| 105 1/2/2008 55 Check grade Labor $87.50
| 104 1/2/2008 307 Level stockpile site 972 $225.00
| 108 1/3/2008 56 Exc center hole Bobcat_MiniEx $85.50
| 104 12/20/2007303 Level stockpile site 972 $225.00
|
| What I need to do is say for instance "how much in total was spent for code
| 104"?
| I need a formula that will search code 104 in the CODE column and then add
| together the total amount that was spent. Which would give an answer of $450
|
|
|
| --
| Christina
|
|
| "Niek Otten" wrote:
|
| > 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
| >
| > |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
| >
| >
| >
