Counting entries in a cell

T

Tom

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.
 
T

Tom Ogilvy

numitems =
len(cell.formula)-len(application.substitute(cell.formula,"+",""))+1

if numItems > 0 then
avg = cell.value / numItems
 
Top