Try the below which will get you the count of postcodes starting with EH

=COUNTIF(A:A,"EH*")


If this post helps click Yes
---------------
Jacob Skaria


"Onyx" wrote:

I'm wanted to build a formula that will do the following,

CountIF(Column begins with array) I can't see to get the function to work.

Reallife example

Count a column of postcodes to find any postcodes beginning with EH, LG,
etc... and giving me a total