I could not replicate what you mentioned.

I entered some numbers in A1:A10, selected the range and clicked on Auto Sum
button and got =SUM(A1:A10). Same result with Alt-=.

I also inserted Subtotals and tried the above. I again got Sum and not
Subtotal.

Perhaps if you can describe the steps you are taking...
"Pearl" wrote:

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!