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

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

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

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