If you have a filter applied then it will automatically select subtotal
instead of sum since subtotal ignores filtered rows
whereas sum will sum all rows

--


Regards,


Peo Sjoblom

"Pearl" wrote in message
...
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!