Type the next consecutive number below the last number in your list. For example, if cell G50 contained "120," type "121." Click and drag your mouse across both cells to select them.

All of these puzzles relate to adding together consecutive numbers. Mathematicians do not like doing a lot of, tedious adding up, and so are always on the lookout for cunning shortcuts.

How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.

Launch Excel or open an existing table with numbers to add.; Type the calculation into the cell you want to place the result, for eg =15+25+4+10+5,; Press the Enter key to see the result. 2] How ...

Step 1: Numbers is smart enough to know which numbers you want to add if they’re in a column or a row. So, you don’t have to select the cells first unless you prefer to do so.