Countif/Left

[JimS]

I have a column of data comprised of letters and numbers. I would
like to count the cells that start with M. Also, does it matter if
the text in the cell is centered or not? If it is centered and that
matters then it would not be at the left most of the cell.

Any help appreciated.

 

[T. Valko]

Try this:

=COUNTIF(A1:A100,"M*")

 

[Ragdyer]

If the data was centered using the <space bar>, try this:

=SUMPRODUCT(--(LEFT(TRIM(A1:A25))="m"))

If it was centered by formatting, try this:

=Countif(A1:A25,"m*")

 

[JimS]

Thanks for both responses.

 

[Shane Devenshire]

Hi,

And if you need the count to be case sensitive:

=SUMPRODUCT(--EXACT(LEFT(D47),"M"))

or where centering is caused by spacebar, (quite unusual, that)

=SUMPRODUCT(--(EXACT(LEFT(TRIM(D47)),"M")))

 

[RagDyeR]

We appreciate the feed-back.