Thread: How to add the same cell on multiple spreadsheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default How to add the same cell on multiple spreadsheet?
If those sheets are contiguous, say sheets 1 through 6, use

=SUM(Sheet1:Sheet6!A2)


"Derrard" wrote:

If I have multiple spreadsheets with a subtotal on the same cell on each
sheet, say cell "A1". How do I add all these numbers up without clicking on
each cell to add to the Sum function?
Reply With QuoteReply With Quote