Hi Biff,

"Biff" wrote in message
...
Hi Bob!

That returns #VALUE! due to the array of range references being passed to
Sumproduct.
=SUMPRODUCT(TRANSPOSE(N(INDIRECT("'"&H1:H2&"'!A1") ))*(N(INDIRECT("'"&H1:H2&"
'!A1"))<100))

Can you say that in a different way as I don't know what you mean.

Also, if:

Sheet1A1 = 100
Sheet2A1 = 10

Formula returns: 110

Not here it doesn't!