Forum Discussion
Excel Sum Function
Everytime I hit auto sum, my formula defaults to subtotal instead of sum? This is frustrating, when I hit auto sum function it should sum. Can it to sum at all? Only subtotal. How can I fix?
ehoward73401 Are you adding Autosum to a structured table? If so, "my" Excel defaults to =SUBTOTAL(109,......), which is basically the same as SUM, though it excludes hidden (filtered out) rows
If you Autosum a regular range it should give you =SUM(........).