| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make "countif" on a filtered excel-list? i.e. like subtotal | Excel Worksheet Functions | |||
| How can I make the autosum refer to visable rows / filter? | Excel Worksheet Functions | |||
| Autosum button performing subtotal | Excel Discussion (Misc queries) | |||
| How to make autosum update totals in excel | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
