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" 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 > > . >