Apr 08 2022 04:53 PM
Why isn't the SUM function working as it used to? I used to put in the sum function then put in the first parenthesis, scroll to the first cell I wanted to add (usually the one just above my total) and then highlight the entire column. How do I do that now??? It's not working. Help please.
Apr 09 2022 03:07 AM
It should still work. If you want to sum the cells immediately above the active cell, you can also press Alt+=
Apr 09 2022 03:19 AM
Apr 09 2022 10:50 PM
Apr 09 2022 11:48 PM
Let say you want sum from A1 to A10,
Then Sum(A1:A10) will work. You can just write SUM( and drag from A1 to A10. It will work.