Forum Discussion
Need 1 worksheet to add totals from multiple worksheets in the same file.
OK now that's COOL!!!! I had no idea you could use a wildcard in the sheet name. I created sheet names: "Sheet1", "Sheet2", "3", "Sheet4", "5", "Sheet6"
and then typed =SUM('Sheet*'!A1:B1) and on Sheet1 it was changed to: =SUM(Sheet2!A1:B1,Sheet4!A1:B1,Sheet6!A1:B1)
don't know how I will use this but very cool! Thx for sharing.
Similarly, created sheets 'Jan' & 'Feb' then on 'Sheet1' =SUM('*'!A1:A100) translated as =SUM(Jan:Feb!A1:A100)
don't know how I will use this but very cool! Thx for sharing
+1
* asterisk means all sheets except current sheet. Even if you enter the formula to middle sheet, then it will automatically update sheet references like. Suppose you have 5 sheets in a workbook. You entered =SUM('*'!A1:A10) to Sheet3. Then formula will automatically updated to
=SUM(Sheet1:Sheet2!A1:A10,Sheet4:Sheet5!A1:A10)
