Hello!
No filters. I have two journals that have negative sum of the numbers above
each one respectively as the opposing entry, and all nets to zero in total.
However, if I want to show a total row beneath all Excel is subtotaling the 2
individual summed totals above rather than summing the total of all the
lines, which you need to do to proof out journal entries on the ledger.

When I tried AutoSum, or even Alt+=, both insert SUBTOTAL beneath each
individual JE, rather than SUM(). When I hit AutoSum, I expect a SUM()
formula, not SUBTOTAL(), which is what I'm getting, which is what it used to
do. If I manually type SUM(), then everything works fine, but I just want to
change AutoSum to be the SUM() formula because in financial applications you
use SUM() way more than you do SUBTOTAL(). Any ideas?



"Peo Sjoblom" wrote:

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!