ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   running totals, named formulas (https://www.excelbanter.com/excel-worksheet-functions/141935-running-totals-named-formulas.html)

Memento

running totals, named formulas
 
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.



Roger Govier

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.






All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com