Help With Formula

[Guest]

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]

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.

 

[Guest]

It works perfectly, Thanks sooo much and thanks for the tip as well.

Fred

 

[David Biddulph]

Well, for a start, your parentheses don't match. Sort those out first, and
then the experts on the group might be able to see what you're trying to
achieve.

 

[Guest]

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

 

[Guest]

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

 

[Bob Phillips]

Maybe this is what you want

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

--
HTH

Bob Phillips

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

 

[Guest]

It's close, but it isn't adding correctly. I'm getting 59 instead of 11

 

[Guest]

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

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