I notice that this is an old post but I am having the same issue. I recently changed from Excel 2003 to Excel 2010 and sometimes save workbooks backwardly compatible to the older version because my church uses it. I have noticed that my numbers do not calculate properly when using the "SUM" function but I'm not sure where the problem arose. What I see is "=SUBTOTAL(9,D74:D82)" but while working Excel 2010 if I click "SUM" and redo the function I receive "=SUM(D74:D82)". I dont' know what to do because there are too many of these occurrences for me to know where they are and change each and every one. Can anyone tell me how this happens so that I can avoid it in the future?
Quote:
Originally Posted by Pearl
Since the upgrade to Office07 (yuck), pushing the AutoSum button, or Alt+=
gives me a SUBTOTAL() function instead of SUM. Of course I can manually type
the SUM formula, but that isn't the point. I'm trying to sum a few general
ledger journal entries to validate that they equal zero, and am now getting
totals because it isn't summing the whole, but the SUBTOTAL pieces only - and
who needs normally? Anyway, other than re-mapping my keyboard shortcut, or
manually typing SUM(), is there any way to direct AutoSum to really do a
AutoSum, not a SUBTOTAL?
Thanks!
|