Adjusting and modifying an equation Sumproduct with Indirect

[Hany ali]

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

=IF(R6="","",SUMPRODUCT(--(INDIRECT("'"&SheetNames&"'!$ap$3:$ap$76")>=$R6),--(INDIRECT("'"&SheetNames&"'!$aQ$3:$aQ$76")<=$R6),(INDIRECT("'"&SheetNames&"'!$ar$3:$ar$76"))))

 

[Hany ali]

Up Please

 

[p45cal]

try, in S6:

=IF(R6="","",SUMPRODUCT(--(INDIRECT("'"& $D$6 &"'!$ap$3:$ap$76")<=$R6),--(INDIRECT("'"&$D$6&"'!$aQ$3:$aQ$76")>=$R6),(INDIRECT("'"&$D$6&"'!$ar$3:$ar$76"))))

 

[Hany ali]

Thank you very much, you are a genius, this is what is needed