vlookup
 

Hey, I was wondering if you could all help me out. I'm trying to use the
vlookup command to give me a sum of values that meets my requirements. Right
now, it is only returning one value of the array.

Is there a way to return the sum of all values that meet my "lookup_value"?
Or maybe there is a better way to do this. Please let me know!

vlookup
 

VLookup returns the first item it finds that matches your criteria.

Check excel help for the SUMIF function. For more complex operations or
criteria, check into SUMPRODUCT
http://xldynamic.com/source/xld.SUMPRODUCT.html

As examples, either of the following formulas will total the values in A1:A5
that are greater than 3.

SUMIF(A1:A5,"3")
SUMPRODUCT(--(A1:A53),A1:A5)

"Mike" wrote:

Hey, I was wondering if you could all help me out. I'm trying to use the
vlookup command to give me a sum of values that meets my requirements. Right
now, it is only returning one value of the array.

Is there a way to return the sum of all values that meet my "lookup_value"?
Or maybe there is a better way to do this. Please let me know!