As a result, when we copied the formula down, it adjusted the position of the second term. Walter Hickey / BI Let's fix the formula and write B$1 instead of B1.

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 "+." ...