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?
Sorry, missed your answer, had some break between starting an answer and POST
SergeiBaklan No problem! In fact, your answer reveals a difference between Excel's behaviour on Windows and Mac. On a Mac (i.e. my Mac, MS365, Insider) a clean filter defaults to SUBTOTAL(109,.....)
That's different behavior for tables and ranges. For ranges SUM() returns back if clean the filter.