Forum Discussion
Solved
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...
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.
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.
