Forum Discussion
Pegi C
Aug 04, 2022Copper Contributor
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...
- Aug 04, 2022
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
Aug 04, 2022MVP
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.