| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
