Formula stopped calculating, now displays formula rather than result I am using

Question

Formula stopped calculating, now displays formula rather than result

I am using Excel 2007, in my spreadsheet I have used the same formula: {=SUM(D2:D34*F2:F34)} changing the last set (F2:F34) to reflect each new column. The formula works perfectly each time for 5 columns the started displaying the formula in the cell rather than the result. The cells are set to currency just like the ones in which the formula works. I have copied and pasted from cell to cell to no avail, I have copied and pasted to a new sheet-still not working. I have completely started a new sheet reentering formulas, my formula no longer works. When I click into a cell with a working formula and attempt to copy it the brackets disappear making the formula stop working even if I manually reinsert the brackets in the formula bar. Can anyone tell me what happened and most importantly how can I fix it?

Explanation / Answer

Hi,<M>?,m

If you're sure that the formula cell isn't formatted as TEXT then try this:-

Formulas tab | Calculation group | Calculation options and ensure that 'Automatic' is selected.

As an aside I wouldn't use that ARRAY formula, I would use this simpler one.

=SUMPRODUCT(D2:D34*F2:F34)

If you stick with your array formula then you can't type those curly brackets, you do it like this

This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter. If you do it correctly then Excel will put curly brackets
around the formula {}. You can't type these yourself. If you edit the formula
you must enter it again with CTRL+Shift+Enter.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.