Forum Discussion
Possibility to have a more practical formula
Dear All, thank you in advance for your support. I have this formula which, as you can see, refers to multiple sheets, is there a simpler way of how to get the results I need (Formula Below) =IF(D5...
AlbertM1960 Create a range on the same sheet as the cell with the formula, with formulas referring to H2 on the sheets 1 to 11.
For example in F1 ='1'!H2, in F2 ='2'!H2 etc.
You can then use
=SUMIF(INDIRECT("'"&MATCH(D5,F1:F11,0)&"'!C23:C48"),Payslip!N5,INDIRECT("'"&MATCH(D5,F1:F11,0)&"'!R23:R48"))