Another Excel calculation bug? Maybe; maybe not

Regarding Excel 98 calculation bugs, Steve Schrier writes: "I have been able to duplicate a bug reported in Woody's Office Watch. The bug involves Natural Language Formulas and may be duplicated as follows:

1. Type "Sales" in A1 (no quotes)
2. Enter some figures in A2:A5
3. Type the formula =SUM(Sales) in C3
4. Enter some figures in A6:A8
5. Type the formula =SUM(Sales) in C4

You now have the same formula in C3 and C4, giving different results! No method of forced recalculation will correct it."

Update: John Bonevich writes: "I entered the data into Excel 98 as outlined. The initial calculation bug is present, but all I had to do was double-click in the C3 cell to get it to synchronize to the new data range A2:A8. So I don't think this is really a bug per se, just non-intuitive programming on Microsoft's part."

Another reader similarly adds: "This is a non-bug. There is a quite standard method of forced recalculation that will correct it. Type Command-H to bring up the Replace dialog, enter '=' in both fields, and hit 'Replace All.'"