Adding cells

T

tommy

Hi, I Wonder if any one can help?, what I would like to do is in cell A1 add
up a load of numbers by using the = sign and then 10+8+9 and so on, then in
cell A2 I would like to have a formula that would add up the number of
numbers I key in so A2 would be 3 in this example.
Thank you in advance ,Tommy.
 
D

Dave Peterson

Select A2
Then use:
Insert|Name|Define
In the "Names In Workbook" box, type:
GetFormulaAbove
In the "refers to box", type:
=GET.FORMULA(A1)

Then use this formula in A2:
=LEN(GetFormulaAbove)-LEN(SUBSTITUTE(GetFormulaAbove,"+",""))
+(LEN(GetFormulaAbove)>0)
 
Top