Thread: summary values across worksheets within the same workbook
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ormond Ormond is offline
external usenet poster
  
Posts: 2
Default summary values across worksheets within the same workbook
In cell C34 on your summary sheet you,
will enter =SUM(Sheet1:Sheet53!C34). The formula adds the contents of cell C34 on Sheet1 through Sheet53. In C34 type =SUM( to begin the function. Activate Sheet1 Press Shift and activate Sheet 53 to group the worksheets and specify the worksheet range in your formula. Release the Shift key. In the active worksheet, select C34 and press the ENTER key to complete the 3-D formula.

---
frmsrcurl: http://msgroups.net/microsoft.public...-the-same-work
Reply With QuoteReply With Quote