So now you find the problem! <g I missed it myself but I
didn't test anything!

I still stand by the vote of confidence I gave you in his
other thread!

Biff

-----Original Message-----
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
om...
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


.