 |
 | 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 / May 2008Sum of Vlookup
I have my lookup table, which is has a defined name of Code1 (see below). Can a Vlookup formula that would look in cell CU4, which has the Code 10, and return the sum of all the Code 10's in the lookup table. In this example the result would be 12. Code 1 Description Total Hours 1 30 Dispatch 8.00 34 Regular Holiday Dispatch 8.00 10 Small Vehicle 4.00 10 Small Vehicle 8.00 =SUMIF(A1:A10,10,C1:C10) Asuming Codes in Column A and Hours in Column C >I have my lookup table, which is has a defined name of Code1 (see below). >Can a Vlookup formula that would look in cell CU4, which has the Code 10, [quoted text clipped - 8 lines] > > 10 Small Vehicle 8.00 WOW, that was great. Thank you very much. > =SUMIF(A1:A10,10,C1:C10) > [quoted text clipped - 12 lines] >> >> 10 Small Vehicle 8.00 You're welcome. > WOW, that was great. Thank you very much. > [quoted text clipped - 14 lines] >>> >>> 10 Small Vehicle 8.00 |
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.