Search and calculate formula
Perfect thank you!
--
Christina
"Niek Otten" wrote:
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 DataSubtotals to see all the details and all the totals in one report
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Xina5280" wrote in message ...
| 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
|
| "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
|
|
|
|