eirikdaude
Board Regular
- Joined
- Nov 26, 2013
- Messages
- 93
- Office Version
- 365
- Platform
- Windows
I have a worksheet which looks something like this:
Cell B1 has the formula
And B5 has the formula:
Is there any way to simplify the formula in B6, or am I stuck with what I have if I want to sum the cell over the last 10 weeks?
Cell B1 has the formula
Excel Formula:
=ISOWEEKNUM(TODAY())
And B5 has the formula:
Excel Formula:
=IFERROR(INDIRECT(B1&"!B5";TRUE);0)+IFERROR(INDIRECT((B1-1)&"!B5";TRUE);0)...+IFERROR(INDIRECT((B1-9)&"!B5";TRUE);0)
Is there any way to simplify the formula in B6, or am I stuck with what I have if I want to sum the cell over the last 10 weeks?