View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tezza tezza is offline
external usenet poster
 
Posts: 3
Default How to sum one cell across workbook if nr of worksheets is variabl

I have a slowly expanding workbook. I wish to have one sheet summarisig the
others. How can I get excel to sum one cell in every worksheet in the book
without having to specify the first and last sheet identities specifically?
e.g. just sum every A1 cell in the book irrespective of number of sheets?
Any help please?