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


"Fred "Djinn" Holstings" wrote:

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