Hello My Dear ..Kindly help me in adjusting and modifying this equation to make it work and produce a result based on the name of the page in cell D6 of the Input page, knowing that the equation starts from cell S6. Thank you very much
Code:
=IF(R6="","",SUMPRODUCT(--(INDIRECT("'"&SheetNames&"'!$ap$3:$ap$76")>=$R6),--(INDIRECT("'"&SheetNames&"'!$aQ$3:$aQ$76")<=$R6),(INDIRECT("'"&SheetNames&"'!$ar$3:$ar$76"))))