Countif with nested function not working?

I'm attempting a countif that reads - COUNTIF(A:A,LEFT(A:A,1)=X)
Where column A looks something like:
XYZ
MNOP
XMN
LKJ
XTR

What's the proper way to do this?
Thanks!

One way:

=COUNTIF(A:A,"X*")

In article <[email protected]>,
jshuatree <[email protected]>
wrote:

> I'm attempting a countif that reads - COUNTIF(A:A,LEFT(A:A,1)=X)
> Where column A looks something like:
> XYZ
> MNOP
> XMN
> LKJ
> XTR
>
> What's the proper way to do this?
> Thanks!

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 <[email protected]>,
jshuatree <[email protected]>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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 <[email protected]>,
jshuatree <[email protected]>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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 <[email protected]>,
jshuatree <[email protected]>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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 <[email protected]>,
jshuatree <[email protected]>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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 <[email protected]>,
jshuatree <[email protected]>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>