Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am interested in doing a count of entries within a cell. It would be
similar to a word count, but instead of counting words, I need to count the plus signs (+) or something like that. I have a simple formula in the cell like: =100+1235+3456+0987+etc and am only interested in determining how many entries are in there since each number entry represents a program and I would like to know how many programs are accounted for. I've tried this variation on the word wount, but no success: =IF(LEN(TRIM(B4))=0,0,LEN(TRIM(B4))-LEN(SUBSTITUTE(B4,CHAR(43)," "))+1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting entries | Excel Worksheet Functions | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
Counting Duplicate Entries | Excel Worksheet Functions | |||
Counting Entries | Excel Worksheet Functions | |||
Counting Entries in a Cell | Excel Worksheet Functions |