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.