Don't know what's been happening with the servers lately, but this post:
<<"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"
This is the first post that I can see from you in regards to this thread or
the OPs first thread.
Since Gary's thanking you for something, I guess he can see your
submissions.
I notice a greater number of posts appearing that don't make any sense,
meaning that more and more of them are not coming through all of the MS
servers, and the threads are being fragmented.
I've posted suggestions to several threads, where I could only see the OP
through the post of another responder to that thread.
And you say that you gave me a vote of confidence?<g
Gee ... that's nice.
Too bad I missed that one!<vbg
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------
"Biff" wrote in message
...
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
.
|