In article ,
hillmic 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! :)