I should probably also say that BPQ is a workbook range, not a worksheet
range.

"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