Sum of several sheets

  • Thread starter Thread starter booshi
  • Start date Start date
B

booshi

I want to make a summary sheet for several other consecutive worksheets in
the workbook. I made something like:

cell B1 cell C1
Jan 02 =SUM(Sheet1:INDIRECT(B1)!F1)

This doesn't work.
Pls help.
 
Hi
is Jan 02 also a sheetname and do you want the value ONLY from this
sheet. If yes you may use something like
=INDIRECT("'" & B1 & "'!F1")
 
Back
Top