Hi,

hope somebody can help a total spreadsheet noob like me...

Problem:

I want to keep a running total in column C of amounts I input in column A, i.e. I have one input field (A1) and one running total field (C1) which gives me the total of all amounts I input in A1 over the course of time...

My solution involved entering x amount into column A and a function =(A1+C1) which gives me error 522 (recursion)

I have looked at help and come to the conclusion that I am attempting an iterative calculation!? but haven't got much further yet.

Any hint or advice would be much appreciated.