Forum Discussion
Solved
Auto fill Problem using INDIRECT() inside a SUMIFS() formula
i really need help When i am Trying to auto fill my formula, Row Range Still Fixed i can't make it fill series =SUMIFS(INDIRECT("'"&$F$2&"'!A9:D9");'1'!$A$6:$D$6;$B$2;'1'!$A$8:$D$8;$D$3) Range ...
AGB200 Okay! Then you can use OFFSET. I believe that's what you have seen before. Have a look in the attached file, Sheet 0 column D. would that work for you?
Thanks a lot for you response, i have some reason for making monthly sheet, so I need function that make the same as you saw, and actually I saw some people use row() insist of range but I don't know how to do it but thank you very much for your time
AGB200 Okay! Then you can use OFFSET. I believe that's what you have seen before. Have a look in the attached file, Sheet 0 column D. would that work for you?