The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this?

  •  The AutoSum formulas refer to the column to the left of their cells.
  •  The AutoSum formulas exclude the bottom row of data.
  •  The AutoSum formulas include the year at the top of each column in the calculation.
  •  The AutoSum formulas include their own cells, creating a circular reference.

Leave a Reply

Your email address will not be published. Required fields are marked *