Thread: Sum Indirect
View Single Post
  #3   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
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.a...tions/201004/1

Reply With QuoteReply With Quote