Thanks Biff. That seems to work.
What does one do if your worksheets are named, June, July, August etc.?

"Biff" wrote:

Hi!

Try it like this:

C10 = ="A"&ROW()

=SUMPRODUCT(N(INDIRECT("Sheet"&ROW(INDIRECT("2:3") )&"!"&C10)))

Biff

"Gdcprogrc" wrote in message
...
For example
=SUM(INDIRECT(C10))
where C10 would contain
="Sheet2:"&"Sheet3!"&"A"&ROW()
always returns #REF!.
However, ="Sheet3!"&"A"&ROW() as the Cell C10 entry will work fine.