| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am in search of formula | Excel Discussion (Misc queries) | |||
| SEARCH FORMULA | Excel Discussion (Misc queries) | |||
| I need help - search formula | Excel Worksheet Functions | |||
| Search formula | Excel Worksheet Functions | |||
| Search within formula | Excel Worksheet Functions | |||
Hybrid Mode
