ExcelBanter - count function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - count function (https://www.excelbanter.com/excel-discussion-misc-queries/196585-count-function.html)

lightbulb

count function

Is there a way to enter a formula that counts the number of cells that start
with "MC" within a certain range? I.E. - Count the cells from U9:U278 that
start with MC...I tried =COUNT(LEFT(U238:U240,2)="MC") but this did not work.

Any help?

Thanks!

Peo Sjoblom[_2_]

count function

=COUNTIF(U238:U240,"MC*")

--

Regards,

Peo Sjoblom

"lightbulb" wrote in message
...
Is there a way to enter a formula that counts the number of cells that
start
with "MC" within a certain range? I.E. - Count the cells from U9:U278
that
start with MC...I tried =COUNT(LEFT(U238:U240,2)="MC") but this did not
work.

Any help?

Thanks!

Mike H

count function

Try

=SUMPRODUCT(--(LEFT(U238:U240,2)="MC"))

Mike

"lightbulb" wrote:

Is there a way to enter a formula that counts the number of cells that start
with "MC" within a certain range? I.E. - Count the cells from U9:U278 that
start with MC...I tried =COUNT(LEFT(U238:U240,2)="MC") but this did not work.

Any help?

Thanks!

All times are GMT +1. The time now is 08:54 PM.