View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Onyx Onyx is offline
external usenet poster
 
Posts: 2
Default Countif left and alphanumberical data

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