Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting entries in a cell
We often use a cell as an "adding machine" and would have
an enrty such as =12+2+45+32+14 The result would obviously return the value of 105 Can anyone think of a way to COUNT the number of entries (in this case 5) so that the frequency or average could automatically be calculated ? Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting entries in a cell
numitems =
len(cell.formula)-len(application.substitute(cell.formula,"+",""))+1 if numItems 0 then avg = cell.value / numItems -- Regards, Tom Ogilvy "Tom" wrote in message ... We often use a cell as an "adding machine" and would have an enrty such as =12+2+45+32+14 The result would obviously return the value of 105 Can anyone think of a way to COUNT the number of entries (in this case 5) so that the frequency or average could automatically be calculated ? Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Counting multiple number entries in a single cell | Excel Worksheet Functions | |||
Counting Continguous Cell Entries | Excel Discussion (Misc queries) | |||
Counting cell entries | Excel Worksheet Functions | |||
Counting Entries | Excel Worksheet Functions | |||
Counting Entries in a Cell | Excel Worksheet Functions |