Forum Discussion
Change the sheet a cell references based on the Value of a dropdown
Hi, I have the formula below: =SUMPRODUCT(('Plot 5'!$Y$4:$DH$4='G1'!D$7)*('Plot 5'!$F$6:$F$15='G1'!$C10)*'Plot 5'!$Y$6:$DH$15) This formula works based on the values in the sheet 'Plot 5'. I ...
Sheet names with spaces must be enclosed in single quotes, so
=SUMPRODUCT(INDIRECT("'"&C6&"'!Y4:DH4"='G1'!D$7))*(INDIRECT("'"&C6&"'!F6:F15"='G1'!$C9))*(INDIRECT("'"&C6&"'!Y6:DH15"))