Forum Discussion
Excel worksheet formula question
I am using PC Windows 11 and Microsoft 365. I am creating a yearly workbook with 12 worksheets (tabs). I want to create formulas that involve data from the prior worksheet. For example, on worksheet ...
NikolinoDE I don't mind doing that, but I don't know how to attach the workbook file.
NikolinoDE error message "The file type (.xlsx) is not supported."
That formula should be enough for you project and it should also work :),
you can then transfer this to your cells as you wish.
=SUM('Jan 2022'!B3)-SUM('Dec 2021'!B3)
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
- it doesn't work when I copy/create a new worksheet, because on the new worksheet, it keeps the same formula, =SUM('Jan 2022'!B3)-SUM('Dec 2021'!B3) when the new formula needs to be =SUM('Feb 2022'!B3)-SUM('Jan 2022'!B3). I'm hoping there is a formula that indicates like "=SUM('prior worksheet'!B3)-SUM('current worksheet'!B3". That way, no matter how many times you copy a worksheet and add it to the end of the workbook, the formulas are in place and don't need to be changed. Does that make sense?