How about something like:

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

You'll want to watch your ()'s and "'s.



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

--

Dave Peterson