Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |