Hi,
Let's say Column A has a list of numbers and at the bottom, there is a Total eg. A11 =SUM(A1:A10)
Now, somehow I want to add a percentage modifier to the Total. I can put this another cell eg. A12 =IF(A3>2,A11*1.066)
But... Is there a way that I can modify the Total ie. A11
I don't want multiple running totals for every modifier. My actual sheet is several hundred rows.
Every way I try it I get a Circular Equation error.
Thankyou
Bookmarks