# My formula isn't working???!

#### Danfrancozola

##### New Member
Hello guys,

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

Thanks a bunch!

Dan

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Hi, maybe:

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

Thank you FormR! Saved me going crazy!

Would I have to do the same with this one?

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

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

Replies
4
Views
268
Replies
2
Views
474
Replies
1
Views
172
Replies
2
Views
96
Replies
5
Views
393

1,220,951
Messages
6,157,030
Members
451,392
Latest member
malcv

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back