View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Renegade Renegade is offline
external usenet poster
 
Posts: 25
Default Excel Function to Count

I have a list of items in various cells in a spreadsheet. For example
(April, May, June, July) as a group in one cell ,and I want to obtain an
actual count of the items in this cell. Is there a way to achieve this
without physically counting each item which has been seprated by a comma? In
my example above, the total count would be (4). Any ideas would be greatly
appreciated.