Sum Indirect

[BNT1 via OfficeKB.com]

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

 

[Bob Phillips]

Try

=SUM(INDIRECT(A4&"!M1:M14"))

 

[BNT1 via OfficeKB.com]

Thanks Bob for the quick response - Worked a treat

regards

Try

=SUM(INDIRECT(A4&"!M1:M14"))

Hi

[quoted text clipped - 8 lines]

regards

 

[Mike H]

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.