That helps but I should have also mentioned that my next step would be to count those entries whose first letter was not X but also included some other variable ie. ended with an O or had a integer greater than some amount.
I don't think this simple method will allow me to do this. As long as I can figure out how to get the nested function to work properly I can manage the rest.
There is no nesting method with COUNTIF.
=COUNTIF(A:A,"X*") + COUNTIF(A:A, "*0") - COUNTIF(A:A,"X*0")
Or you could use the array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):
=SUM((LEFT(A1:A1000,1)="X") + ((LEFT(A1:A1000,1)<>"X") *
(RIGHT(A1:A1000,1)="0")))
In article <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>,
jshuatree <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>
wrote:
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
=SUMPRODUCT(--(LEFT(A1:A10)<>"X"),--(RIGHT(A1:A10)="O"))
>or had a integer greater than some amount.
You'll need to post some examples so we can see what you mean.
Biff
"jshuatree" <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com> wrote
in message news:jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com...
>
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
>
>
> --
> jshuatree
> ------------------------------------------------------------------------
> jshuatree's Profile:
> http://www.excelforum.com/member.php...o&userid=36459
> View this thread: http://www.excelforum.com/showthread...hreadid=562227
>
There is no nesting method with COUNTIF.
=COUNTIF(A:A,"X*") + COUNTIF(A:A, "*0") - COUNTIF(A:A,"X*0")
Or you could use the array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):
=SUM((LEFT(A1:A1000,1)="X") + ((LEFT(A1:A1000,1)<>"X") *
(RIGHT(A1:A1000,1)="0")))
In article <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>,
jshuatree <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>
wrote:
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
There is no nesting method with COUNTIF.
=COUNTIF(A:A,"X*") + COUNTIF(A:A, "*0") - COUNTIF(A:A,"X*0")
Or you could use the array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):
=SUM((LEFT(A1:A1000,1)="X") + ((LEFT(A1:A1000,1)<>"X") *
(RIGHT(A1:A1000,1)="0")))
In article <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>,
jshuatree <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>
wrote:
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
There is no nesting method with COUNTIF.
=COUNTIF(A:A,"X*") + COUNTIF(A:A, "*0") - COUNTIF(A:A,"X*0")
Or you could use the array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):
=SUM((LEFT(A1:A1000,1)="X") + ((LEFT(A1:A1000,1)<>"X") *
(RIGHT(A1:A1000,1)="0")))
In article <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>,
jshuatree <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>
wrote:
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
=SUMPRODUCT(--(LEFT(A1:A10)<>"X"),--(RIGHT(A1:A10)="O"))
>or had a integer greater than some amount.
You'll need to post some examples so we can see what you mean.
Biff
"jshuatree" <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com> wrote
in message news:jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com...
>
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
>
>
> --
> jshuatree
> ------------------------------------------------------------------------
> jshuatree's Profile:
> http://www.excelforum.com/member.php...o&userid=36459
> View this thread: http://www.excelforum.com/showthread...hreadid=562227
>
There is no nesting method with COUNTIF.
=COUNTIF(A:A,"X*") + COUNTIF(A:A, "*0") - COUNTIF(A:A,"X*0")
Or you could use the array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):
=SUM((LEFT(A1:A1000,1)="X") + ((LEFT(A1:A1000,1)<>"X") *
(RIGHT(A1:A1000,1)="0")))
In article <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>,
jshuatree <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com>
wrote:
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
=SUMPRODUCT(--(LEFT(A1:A10)<>"X"),--(RIGHT(A1:A10)="O"))
>or had a integer greater than some amount.
You'll need to post some examples so we can see what you mean.
Biff
"jshuatree" <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com> wrote
in message news:jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com...
>
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
>
>
> --
> jshuatree
> ------------------------------------------------------------------------
> jshuatree's Profile:
> http://www.excelforum.com/member.php...o&userid=36459
> View this thread: http://www.excelforum.com/showthread...hreadid=562227
>
=SUMPRODUCT(--(LEFT(A1:A10)<>"X"),--(RIGHT(A1:A10)="O"))
>or had a integer greater than some amount.
You'll need to post some examples so we can see what you mean.
Biff
"jshuatree" <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com> wrote
in message news:jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com...
>
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
>
>
> --
> jshuatree
> ------------------------------------------------------------------------
> jshuatree's Profile:
> http://www.excelforum.com/member.php...o&userid=36459
> View this thread: http://www.excelforum.com/showthread...hreadid=562227
>
=SUMPRODUCT(--(LEFT(A1:A10)<>"X"),--(RIGHT(A1:A10)="O"))
>or had a integer greater than some amount.
You'll need to post some examples so we can see what you mean.
Biff
"jshuatree" <jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com> wrote
in message news:jshuatree.2b3z7v_1153171511.1624@excelforum-nospam.com...
>
> That helps but I should have also mentioned that my next step would be
> to count those entries whose first letter was not X but also included
> some other variable ie. ended with an O or had a integer greater than
> some amount.
> I don't think this simple method will allow me to do this. As long as
> I can figure out how to get the nested function to work properly I can
> manage the rest.
>
>
> --
> jshuatree
> ------------------------------------------------------------------------
> jshuatree's Profile:
> http://www.excelforum.com/member.php...o&userid=36459
> View this thread: http://www.excelforum.com/showthread...hreadid=562227
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks