Thread: summing same cell in multiple worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default summing same cell in multiple worksheets
=SUM(Sheet2:Sheet5!B3)



"Sinkguy1" wrote:

Is there an easy formula to sum the same cell from multiple worksheets
without typing each one? =sheet2 b3+sheet3 b3+sheet4 b3 etc.. Is there a
formula that will sum cell B3 from all sheets in the workbook?
Reply With QuoteReply With Quote