View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pearl Pearl is offline
external usenet poster
 
Posts: 10
Default How do I make AutoSum really Sum, not Subtotal

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!