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

--
jshuatre
-----------------------------------------------------------------------
jshuatree's Profile: http://www.excelforum.com/member.php...fo&userid=3645
View this thread: http://www.excelforum.com/showthread.php?threadid=56222

One way:

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

In article <(E-Mail Removed)>,
jshuatree <(E-Mail Removed)>
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 b
to count those entries whose first letter was not X but also include
some other variable ie. ended with an O or had a integer greater tha
some amount.
I don't think this simple method will allow me to do this. As long a
I can figure out how to get the nested function to work properly I ca
manage the rest

--
jshuatre
-----------------------------------------------------------------------
jshuatree's Profile: http://www.excelforum.com/member.php...fo&userid=3645
View this thread: http://www.excelforum.com/showthread.php?threadid=56222

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 <(E-Mail Removed)>,
jshuatree <(E-Mail Removed)>
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" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>