|
Help With Formula
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 |
Help With Formula
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 |
Help With Formula
It works perfectly, Thanks sooo much and thanks for the tip as well.
Fred "Dave Peterson" wrote: 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 |
Help With Formula
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. -- David Biddulph "Fred "Djinn" Holstings" wrote in message ... 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 |
Help With Formula
=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 |
Help With Formula
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 |
Help With Formula
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 |
Help With Formula
It's close, but it isn't adding correctly. I'm getting 59 instead of 11
"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 |
Help With Formula
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 |
| All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com