Thread: vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB
 
Posts: n/a
Default 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!