B

#### Brian Winkler

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