INDIRECT
SUMIF(INDIRECT(UDF),E2,L:L)

HTH

Die_Another_Day
"Who I Am" wrote in message
oups.com...
My UDF generates

$E$500:$E$651

When I embedded the UDF into SUMIF, the UDF shows

"$E$500:$E$651"

How can I remove the quotation mark, or is there another option (to
make this SUMIF work)?

Thanks in advance.