Domenic,

That is indeed what I mean.

I originally tried it using the N function, but I must have done something
wrong as it didn't work then (your version does work for me). I then tried
TRANSPOSE and it worked fine, and it worked when I tried again when Biff
replied, and it works again now

Wierd or what?

Wonder if it worked for the OP, or if he even tried it.

Bob

"Domenic" wrote in message
...
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