Count Cells that begin with a specific text

I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero.

=COUNTIF({Reference Sheet}, "ABCD")

Is there a formula to return the number of cells that have the first four letters as "ABCD"?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!