This is the code for the stat on the native page.

=COUNTIF(E11:F61883,"<=" & F9+1)-COUNTIF(E11:F61883,"<=" & F9)

"Bob Phillips" wrote:

Maybe this is what you want

=COUNTIF(INDIRECT("'"&J4&"'!F15:G61887"),"<="&INDI RECT("'"&J4&"'!F9")+1)-
COUNTIF(INDIRECT("'"&J4&"'!F15:G61887"),"<="&INDIR ECT("'"&J4&"'!F9"))

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fred Djinn Holstings" wrote
in message ...
That works perfectly but now I have another need for a similar type of
formula. I thought that I could use what I was given but I still don't
seem
to be able to grasp it.

=COUNTIF(INDIRECT("'" & J4 & "'!F15:G61887,"<="INDIRECT("'" & J4 & "'!
F9+1)-COUNTIF(INDIRECT("'" & J4 & "'!F15:G61887,"<=" & INDIRECT("'" & J4 &
"'! F9)))

As Always Thanks Sooo Very Much!
Fred

"Teethless mama" wrote:

=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