I tried something much like that and got a #REF error.

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(INDIRECT(A1)1))

or


=SUMPRODUCT(--(INDIRECT(Sheet1!A1)1))



--
Regards,

Peo Sjoblom



"Barb Reinhardt" wrote in message
...
Let's say I have cell Sheet1!A1 with the value of BPQ in it.
Let's also say that I have a named range with the name BPQ.

I'd like to reference that named range by referencing Sheet1!A1 somehow
and
use it in a SUMPRODUCt statement. How would I reference the range?

Thanks in advance,
Barb Reinhardt