count function

[lightbulb]

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]

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

--


Regards,


Peo Sjoblom

 

[Mike H]

Try

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

Mike