I have a circular reference in cell L12. The formula in the cell is:
=sum(L8:L11).
The result in L12 is used by about 8 other cells to make decisions. The cell
computes how many contracts to initiate based four different formulas in
cells 8:11.

Thank you for any clues as to how to resolve the conflict.