LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
in excel where is my count/sum function? Steph Excel Discussion (Misc queries) 2 April 3rd 07 03:16 PM
Is there one or combination of Excel function to count unique entr Wellie Excel Discussion (Misc queries) 2 September 8th 06 03:40 PM
excel should have a function to count sheets carlos sosa Excel Worksheet Functions 7 April 24th 05 08:29 PM
Count function in excel with different conditions chits Excel Worksheet Functions 1 January 21st 05 07:32 AM
How can I use count function in excel where I have several criter. Princess V Excel Worksheet Functions 14 November 3rd 04 10:18 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"