Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif based on vlookup array
I'd like to nest a VLOOKUP function returning an array within a SUMIF function but receive a unspecific error message. I'd like to take a column of id values, translate those values into an array of group id's using VLOOKUP, and then use the result as the range argument in the SUMIF formula (first argument). The criteria (second argument) in the SUMIF formula would be a value found in the array of group ids. Can you recommend a way to nest an array of VLOOKUP results into the range argument of SUMIF? thanks -- Brian Winkler ------------------------------------------------------------------------ Brian Winkler's Profile: http://www.excelforum.com/member.php...o&userid=27867 View this thread: http://www.excelforum.com/showthread...hreadid=473736 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |