Count occurrences of string within a cell for entire column

[mawheele]

If I have a a column like:

313111
313112
313111
313144
314256
315876

How would I count occurrences of the string "313" in the beginning of each string, throughout hte column?

For instance, the count on this column would be 4.

Thanks to anyone with suggestions.

 

[Jonmo1]

Try

=SUMPRODUCT(--(LEFT(A1:A100,3)="313"))

 

[Gerald Higgins]

One way is to use a helper column.

If your numbers are in Col A, put this formula in Col B

=left(A1,3)

Then this formula will count the number of entries of 313 in Col B

=COUNTIF(b1:b1000,"313")

 

[mawheele]

Works

Works thank you!