View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NAAPS
 
Posts: n/a
Default summarise totals from many worksheets into one final worksheet

I need to add totals from many worksheets onto one final Summary worksheet.
the formula I create is too long for Excel. is there a way to shorten the
formula eg using the SUM function + Shift or Control keys? I believe Lotus
is able to do this.