Sum Indirect
in [Functions]
|
Prev: How do I use 'between' 95% and 100% for a nested IF function?
Next: numbers in a column are not sorting ascending
From: BNT1 via OfficeKB.com on 6 Apr 2010 07:36 Hi Struggling with this indirect formula - got #ref error exel 2003 A4 = sheet number =SUM(INDIRECT("&A4&!"&M1:M14)) any one able to assist? regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201004/1
From: Bob Phillips on 6 Apr 2010 07:40 Try =SUM(INDIRECT(A4&"!M1:M14")) -- HTH Bob "BNT1 via OfficeKB.com" <u19326(a)uwe> wrote in message news:a61f79aa03a25(a)uwe... > Hi > > Struggling with this indirect formula - got #ref error > > exel 2003 > A4 = sheet number > > =SUM(INDIRECT("&A4&!"&M1:M14)) > > any one able to assist? > > regards > > -- > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201004/1 >
From: BNT1 via OfficeKB.com on 6 Apr 2010 08:11 Thanks Bob for the quick response - Worked a treat regards Bob Phillips wrote: >Try > >=SUM(INDIRECT(A4&"!M1:M14")) > >> Hi >> >[quoted text clipped - 8 lines] >> >> regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201004/1
From: Mike H on 6 Apr 2010 08:22
Hi, Is this what you want? =SUM(INDIRECT(A4&"!M1:M14")) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "BNT1 via OfficeKB.com" wrote: > Hi > > Struggling with this indirect formula - got #ref error > > exel 2003 > A4 = sheet number > > =SUM(INDIRECT("&A4&!"&M1:M14)) > > any one able to assist? > > regards > > -- > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201004/1 > > . > |