Thread: Sum Indirect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
  
Posts: 125
Default Sum Indirect
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.a...tions/201004/1

Reply With QuoteReply With Quote