You mean your formula returns a correct value? Interesting, since both
Biff and I get a #VALUE! error. It seems that TRANSPOSE doesn't effect
the necessary de-referencing.

In article ,
"Bob Phillips" wrote:

Hi Domenic,

It might if you can tell me why I don't get #VALUE!

Bob

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

I believe the reason the formula returns a #VALUE! error is due to
'de-referencing'. As Biff has already shown, the function N() can be
used for this...

=SUMPRODUCT(N(INDIRECT("'"&H1:H2&"'!A1"))*(N(INDIR ECT("'"&H1:H2&"'!A1"))<
100))

Hope this helps!

In article ,
"Bob Phillips" wrote:


=SUMPRODUCT(TRANSPOSE((INDIRECT("'"&H1:H2&"'!A1")) *(INDIRECT("'"&H1:H2&"'!A1
")<100)))

--
HTH

Bob Phillips