software

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 quot;lookup_valuequot;?
Or maybe there is a better way to do this. Please let me know!

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
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,quot;gt;3quot;)
SUMPRODUCT(--(A1:A5gt;3),A1:A5)

quot;Mikequot; wrote:

gt; Hey, I was wondering if you could all help me out. I'm trying to use the
gt; vlookup command to give me a sum of values that meets my requirements. Right
gt; now, it is only returning one value of the array.
gt;
gt; Is there a way to return the sum of all values that meet my quot;lookup_valuequot;?
gt; Or maybe there is a better way to do this. Please let me know!