I'm trying to create a sheet for statistics and the Stat sheet needs to
reference the sheet that is selected in Cell J4 but I'mm betting a Ref error.
Here's the formula that I'm trying to use.

=IF(COUNTIF(Indirect("'" & J4 & "'!A:A," & "595"")<0,COUNTIF(Indirect("'" &
J4 & "'!A:A," & "595""),"Nothing to Count")


Thanks In Advance,
Fred