Forum Discussion
Need 1 worksheet to add totals from multiple worksheets in the same file.
undefined
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)