HHave imported a workbook from Ms excel containing 15 worksheets.
how do I access data from one worksheet to another?
iMac, OS X Yosemite (10.10.5)
Hi
I have finally got a version that does not have a syntax error regrettably it does not do what I require.
DH
Hi
this gives syntax errors.
DH
Hi Dhand,
SUMIF(INDIRECT(F$2&”::Table 1::g4:g200”,$D70,INDIRECT(F$2&”::Table 1::D4:D200”,)
The good news is you are getting close.
SUMIF(INDIRECT(F$2&”::Table 1::g4:g200”),$D70,INDIRECT(F$2&”::Table 1::D4:D200”))
Should do it.
Numbers works hard to make our lives easier. Using quotes can misdirect it- you might in the future enter your double quotes then add your values between them.
quinn
Hi
Gives an "invalid reference" error
DH
Invalid reference means you have supplied a range that doesn't exist. We can't see your sheet names and tables so we don't know exactly where the problem might be be.
The "Numbers way" would be something more like this:
=SUMIF(INDIRECT(F$2&"::Table 1::G"),$D$70,INDIRECT(F$2&"::Table 1::D"))
SG
TThank you.
is there no equivalent of excel indirect address function.
MMany thanks. That makes things a lot clearer.
i Will certainly try to avoid Indirect, I have always found it troublesome.
DHand
Hi thanks for your reply.
However your suggestion about the editor does not work it still comes up with "lozenges"
Can these be stopped?
DH
It's difficult to tell from your general description where you are running into problems. Would you consider posting screenshots?
SG
Hi
Just noticed a syntax error in the first part.
Even when corrected I still get syntax errors.
DH
With the formula editor active can you command-a to select all and paste that into a post?
You seem to have extra * in the formula, and there may be other problems.
SG
Hi
Thank you you noticed the typo in the message, it is correct in the proper formula.
DH
Hi Dhand,
The address you are supplying to INDIRECT() is "F$2Table 1::G4:G200". I don't think this is what you intend. What is the value in F$2?
quinn
Hi the value in F$2 is the name in clear text of the sheet I wish to reference
DH
SUMIF(INDIRECT(F$2&”::Table 1::g4:g200”,$D70,INDIRECT(F$2&”::Table 1::D4:D200”,)) |
DH
Obtain data from other sheets
