| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Vlookup
=SUMIF(A1:A10,10,C1:C10)
Asuming Codes in Column A and Hours in Column C "Patrick C. Simonds" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Vlookup
WOW, that was great. Thank you very much.
"Gaurav" wrote in message ... =SUMIF(A1:A10,10,C1:C10) Asuming Codes in Column A and Hours in Column C "Patrick C. Simonds" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Vlookup
You're welcome.
"Patrick C. Simonds" wrote in message ... WOW, that was great. Thank you very much. "Gaurav" wrote in message ... =SUMIF(A1:A10,10,C1:C10) Asuming Codes in Column A and Hours in Column C "Patrick C. Simonds" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
