Circular Ref.

[storm01]

I have a figure that copys from C5, to C12, which is ok, but I want the
figure in C12 to be added to D12 and D12 to show the new total.
Does anyone know if this is possible?

Thanks

 

[David Biddulph]

Yes, but circular references should be treated with caution. You'll need to
look at iterations.
http://office.microsoft.com/en-us/excel/HP100662431033.aspx