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!