 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008Search and calculate formula
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!  SignatureChristina Hi Christina, <and then add the amounts in column H> Add to what? Did you look at VLOOKUP()? SignatureKind 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 [quoted text clipped - 3 lines] | | Thanks! 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 SignatureChristina > Hi Christina, > [quoted text clipped - 11 lines] > | > | Thanks! 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 SignatureKind regards, Niek Otten Microsoft MVP - Excel | For example: | Code Date Ticket Description Equiptment Total [quoted text clipped - 24 lines] | > | | > | Thanks! Perfect thank you! SignatureChristina > With the codes in A and the Totals in E: > [quoted text clipped - 32 lines] > | > | > | > | Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.