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?
Excel by default use SUBTOTAL(9,.. if the range is filtered. That's to exclude filtered cells from summing. If clean the filter it shall be SUM()