How to manually sum in Excel. 1. Click the cell you want the sum to appear in and click "=." 2. Type a number or click a cell that has a value. 3. Type "+." ...

See how in the formulas of each cell, each of the column and row values that don't have a dollar sign in front of them shift with each cell, while the rows or columns with a dollar sign remain ...