• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adjusting and modifying an equation Sumproduct with Indirect

Hany ali

Active Member
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"))))
 

Attachments

p45cal

Well-Known Member
try, in S6:
Code:
=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"))))
 
Top