B
BimboUK
I wish to use one or two cells to vary part of a worksheet location in a
SUMIF formula.
example =SUMIF('c:\My Documents\[$A$1 C$2.xls]Costing
summary'!$A$28:$A$847,$A5,'c:\My Documents\[$A$1 C$2.xls]Costing
summary'!$C$28:$C$847)
Basically I am wanting to analyse the same range from a costing summary for
each person but also future proof it as A1 = the year and C2 being the name
of the person. The worksheet name is "09-10 A Person".
I have tried INDIRECT but don't understand the SYNTAX correctly yet.
At present I have the info in TEXT format.
If i can get this right I can really use the data I have!!
PS I have tried MoreFunc by ? Laurent using the INDIRECT.ext func and
couldn't get that to work either.
All help greatly appreciated
SUMIF formula.
example =SUMIF('c:\My Documents\[$A$1 C$2.xls]Costing
summary'!$A$28:$A$847,$A5,'c:\My Documents\[$A$1 C$2.xls]Costing
summary'!$C$28:$C$847)
Basically I am wanting to analyse the same range from a costing summary for
each person but also future proof it as A1 = the year and C2 being the name
of the person. The worksheet name is "09-10 A Person".
I have tried INDIRECT but don't understand the SYNTAX correctly yet.
At present I have the info in TEXT format.
If i can get this right I can really use the data I have!!
PS I have tried MoreFunc by ? Laurent using the INDIRECT.ext func and
couldn't get that to work either.
All help greatly appreciated