Don't know why I didn't see this before, but I just happened to notice that
you *have* quotes around C2 and C4 in the first half of the formula, and
*not* in the second half.

*Eliminate* the quotes from C2 and C4!

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"RagDyer" wrote in message
...
Break up the references and try each one separately to insure that they *do*
actually return the value in the cell.

On my test Sheet1,
B1 = sheet2
C2 = a
C4 = b
On Sheet2,
A2 contains the number 555.
B2 contains the number 222

I took this:
=IF(INDIRECT("'"&B$1&"'!"&"C$2"&ROW(A2))

Revised it to this:
=INDIRECT(B1&"!"&C$2&ROW(A2))

And got the return of 555.

I did the same with the second half :
+INDIRECT("'"&B$1&"'!"&"C$4"&ROW(A2))
And revised it to:
=INDIRECT(B$1&"!"&C$4&ROW(A2))

And got the return of 222.

Combining them:

=INDIRECT(B1&"!"&C$2&ROW(A2))+INDIRECT(B$1&"!"&C$4 &ROW(A2))

Gave me a return of 777.

So ... for me ... this formula works by returning the contents of the cells
I referenced.

I don't have any idea what you have in the cells you're referencing.

You should check out your formula, piecemeal, and see if you get exactly
what you expect.

Post back with your results.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------






"gbeard" wrote in message
m...
RD,
I noticed I miss wrote my first explanation. I want a blank cell if the
result is B3 not <B3. I want it to return the sum if it's <B3.

Sorry,

--
Gary Beard