help with =SUMPRODUCT(COUNTIF(INDIRECT("'"&A25:A31&"'!L7:L30"),"<60"))

[pandakor]

=SUMPRODUCT(COUNTIF(INDIRECT("'"&A25:A31&"'!L7:L30"),"<60"))

This is the formula I'm working with. I want to replace the 60 with .60*F3, but of course =SUMPRODUCT(COUNTIF(INDIRECT("'"&A25:A31&"'!L7:L30"),"<(.60*F3)")) does not work. Do I need to insert a new INDIRECT parameter? and, if so, where? What would the new formula be?

 

[Fluff]

Duplicate Having trouble with a formula

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).