View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Picman Picman is offline
external usenet poster
 
Posts: 70
Default How do I count cells that contain a number of charctors.

How do I count cells that contain a number of charctors or specific criteria.
i have a column of cells that contain a range of values and i want to count
only the cells that contain a specific type of value (PO-31233334/M8689901)
vs (31233376/M8694101). If this is not possible then I'd like to count cells
that contain a specific number of charactors (20).