Forum Discussion

Pegi C's avatar
Pegi C
Copper Contributor
Aug 04, 2022

How to search community?

I am learning EXCEL, am a 365 Subscriber and am taking an online course.  Some of the threads I've read are way too advanced for me.  Are there simpler replies? I am taking an online course and some...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Aug 04, 2022

    Pegi C 

    You can use this method with the SUM function.

    Type =SUM(

    Point to a cell, or drag the mouse over a range of cells.

    Excel will add the cell or the range to the formula. If you selected more than one cell, it will use the notation firstcell:lastcell

    Then hold down Ctrl and point to another cell or drag the mouse over another range of cells.

    Etc.

    Finally, type } and press Enter or Tab.

HansVogelaar's avatar
HansVogelaar
MVP
Aug 04, 2022

Pegi C 

You can use this method with the SUM function.

Type =SUM(

Point to a cell, or drag the mouse over a range of cells.

Excel will add the cell or the range to the formula. If you selected more than one cell, it will use the notation firstcell:lastcell

Then hold down Ctrl and point to another cell or drag the mouse over another range of cells.

Etc.

Finally, type } and press Enter or Tab.

Resources