I can't reproduce this on my 2007 unless I apply a filter.
When I do alt + = it sums and when I click the autosum icon it sums.

Btw, how does your subtotal formula look. If it is SUBTOTAL(9,Range)
then it is the equivalent of SUM(Range).

--


Regards,


Peo Sjoblom

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