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!


--
jshuatree
------------------------------------------------------------------------
jshuatree's Profile: http://www.excelforum.com/member.php...o&userid=36459
View this thread: http://www.excelforum.com/showthread...hreadid=562227

One way:

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

In article ,
jshuatree
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.


--
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
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" wrote
in message ...

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