View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default running totals, named formulas

see reply to your earlier posting

--
Regards

Roger Govier


"Memento" wrote in message
...
Another one he

A B C
1 1 2 =TestFormula
2 3 3 =TestFormula
3
4 =A1+B1 (TestFormula)

Is there any way to get the following cells to use the correct values,
so it
would use for C3 the values of row 3, instead as using the formula as
noted.
With parameters, or something likewise.

Or any other means to get this done? problem is that i have very large
formula's, if I have to copy them into every cell, everything works
correctly, but my worksheet eventually becomes very large...

Any ideas, tips or suggestions are welcomed!

Already Thanks.