In article <hillmic.1raiyq_1119884758.4295@excelforum-nospam.com>,
hillmic <hillmic.1raiyq_1119884758.4295@excelforum-nospam.com> wrote:

> I have no idea why... but it works! Thank you so much.
>
> I'm curious why the indirect text argument will work in sumproduct but
> wouldn't work in sum.

Good question! I wish I knew!