My formula isn't working???!

[Danfrancozola]

Hello guys,

Can somebody please help me and tell me why this formula isnt working:

=COUNTIFS(INDIRECT("'"&$B7&"'!$Q$9:$Q$28,">0.5",'!$X$9:$X$28,">0.5"))

Thanks a bunch!

Dan

 

[FormR]

Hi, maybe:

=COUNTIFS(INDIRECT("'"&$B7&"'!$Q$9:$Q$28"),">0.5",INDIRECT("'"&B7&"'!$X$9:$X$28"),">0.5")

 

[Danfrancozola]

Thank you FormR! Saved me going crazy!

 

[Danfrancozola]

Would I have to do the same with this one?

=SUMPRODUCT(('PL1'!$L$9:$L$28>0)*('PL1'!$L$9:$L$28<10))

 

[FormR]

Yes, if you want the sheet name to come from cell B7.

=SUMPRODUCT((INDIRECT("'"&B7&"'!$L$9:$L$28")>0)*(INDIRECT("'"&B7&"'!$L$9:$L$28")<10))

Or the countifs alternative would be:

=COUNTIFS(INDIRECT("'"&B7&"'!$L$9:$L$28"),">0",INDIRECT("'"&B7&"'!$L$9:$L$28"),"<10")