Hi,

I've created a spreadsheet that uses a circular calculation to work out a maximum profit figure from an arbitrage betting situation.

What I'd also like is a cell which gives me a running total of all the profits from each new calculation. The problem is that this cell will refer to itself in order to add the new profit to the existing running total it contains, and it therefore becomes part of the iteration process and simply adds together all the results from each of the iterations required to produce the profit figure in the first place, resulting in a massive total.

Is there a way I can create a cell that adds the end result of the new circular calculation to the figure it already contains but without actually going through the iteration process?

Thank you.