Thread: sum a specific cell in more than one sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
plainclothman plainclothman is offline
external usenet poster
  
Posts: 13
Default sum a specific cell in more than one sheet
I want to sum cell A1 in sheet1,...,sheet100 .I type (sheet1:sheet100)!$a$1
but it doesn't work
Reply With QuoteReply With Quote