How can you put double quotes in the parameter of the INDIRECT() function ?

T

tur13o

How can you put double quotes in the parameter of the INDIRECT() function ?



Example ..



=SUMIF(mysheet1!$B$2:$B$200,">0",mysheet2!F$2:F$200)



I want to run the above formula in the INDIRECT function like .



INDIRECT ("=SUMIF(mysheet1!$B$2:$B$200,">0",mysheet2!F$2:F$200)")



But the " around the >0 is causing a problem because INDIRECT thinks you
have come to the end of the literal parameter - but I haven't - I literally
want the double quotes passed to INDIRECT as part of its parameter.
 
P

Paul

tur13o said:
How can you put double quotes in the parameter of the INDIRECT() function ?
Example ..

=SUMIF(mysheet1!$B$2:$B$200,">0",mysheet2!F$2:F$200)

I want to run the above formula in the INDIRECT function like .

INDIRECT ("=SUMIF(mysheet1!$B$2:$B$200,">0",mysheet2!F$2:F$200)")

But the " around the >0 is causing a problem because INDIRECT thinks you
have come to the end of the literal parameter - but I haven't - I literally
want the double quotes passed to INDIRECT as part of its parameter.
Click to expand...

I think you have misunderstood what INDIRECT does. It converts a text string
representing a reference (to a cell or a range) into a REFERENCE that can be
used in a formula. It does not convert a text string into a FORMULA!

So, you could put INDIRECT("mysheet!$B$2:$B$200") inside your formula. But
you cannot include a text version of a formula inside INDIRECT.
 
Top