I have a column that contains lots of post codes.

E.g

EH48 3SS
EH48 3HU
EH52 6PQ
EH48 3OP
EH48 3ER
EH52 6XW

I'd like to count how many post codes I have that contain "EH48" in the
cell. Could someone tell me how I do this?

Thanks

=COUNTIF(A1:A50,"EH48 *")


--
Regards,

Peo Sjoblom




"Adam" wrote in message
...
I have a column that contains lots of post codes.

E.g

EH48 3SS
EH48 3HU
EH52 6PQ
EH48 3OP
EH48 3ER
EH52 6XW

I'd like to count how many post codes I have that contain "EH48" in the
cell. Could someone tell me how I do this?

Thanks

Here is my thinking. In a separate column you will need to separate the
first four characters out (EH48, EH52, etc....) by typing in =left(clicking
on the cell that contains the postal code,4). Then at the end of the column
you can type in =countif(select the range of the newly separated
characters,"EH48") Hope this helps

"Adam" wrote:

I have a column that contains lots of post codes.

E.g

EH48 3SS
EH48 3HU
EH52 6PQ
EH48 3OP
EH48 3ER
EH52 6XW

I'd like to count how many post codes I have that contain "EH48" in the
cell. Could someone tell me how I do this?

Thanks