Forum Discussion

Lori_U's avatar
Lori_U
Copper Contributor
Apr 08, 2022

Sum column by dragging

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.

Formulas and Functions

4 Replies

  • Mrpranjal's avatar
    Mrpranjal
    Copper Contributor
    Apr 09, 2022
    It should work.
    It would be helpful in analysing if you share a screenshot of what issue you are facing.
    • Lori_U's avatar
      Lori_U
      Copper Contributor
      Apr 10, 2022
      Hi, it looks like if I highlight the first cell, then put in the colon : and drag up, I'm okay. It doesn't work if I just drag as I used to, but until now I was using a very old version of Excel.
      • Mrpranjal's avatar
        Mrpranjal
        Copper Contributor
        Apr 10, 2022

        Lori_U 

        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.

         

         

         

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 09, 2022

    Lori_U 

    It should still work. If you want to sum the cells immediately above the active cell, you can also press Alt+=

Resources