Feb 28 2022 12:04 PM
How do I correct AutoSum back to =SUM(number1,[number2], …) When I click on AutoSum in Editing in the Home Ribbon or in the Formulas Ribbon it inserts the SUBTOTAL FORMULA, =SUBTOTAL(function_num,ref1,[ref2],...).
How do I change it back to =SUM(number1,[number2], …) ?
Feb 28 2022 12:43 PM
This happens when you invoke AutoSum on a filtered range.
If you click AutoSum with a non-filtered range, it should default to SUM.
Feb 28 2022 01:17 PM
Feb 28 2022 01:27 PM