Counting entries in a cell

  • Thread starter Thread starter Tom
  • Start date Start date
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.
 
numitems =
len(cell.formula)-len(application.substitute(cell.formula,"+",""))+1

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