Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 451
- Office Version
- 365
- Platform
- Windows
I have the following code using indirect so it can look at the sheet name from cell (DK$34)
=SUMIFS(INDIRECT("'[MasterData.xlsm]"&DK$34&"'!$AQ10:$MMZ10"),INDIRECT("'[MasterData.xlsm]"&DK$34&"'!$AQ$3:$MMZ$3"),"="&DK$33,INDIRECT("'[MasterData.xlsm]"&DK$34&"'!$AQ$1:$MMZ$1"),"="&$N$2)/DK$32
I need to be able to copy this formula down so the $AQ10:$MMZ10 increments by 1 each time.
I've looked at offsets and rows and row but still can't work it out.
Any help would be appreciated
=SUMIFS(INDIRECT("'[MasterData.xlsm]"&DK$34&"'!$AQ10:$MMZ10"),INDIRECT("'[MasterData.xlsm]"&DK$34&"'!$AQ$3:$MMZ$3"),"="&DK$33,INDIRECT("'[MasterData.xlsm]"&DK$34&"'!$AQ$1:$MMZ$1"),"="&$N$2)/DK$32
I need to be able to copy this formula down so the $AQ10:$MMZ10 increments by 1 each time.
I've looked at offsets and rows and row but still can't work it out.
Any help would be appreciated