Draw a diagram to represent the actual model you plan to make. What to Know To create a formula with references highlight the cells you want to use then select an empty cell and enter the. The easiest way to add a SUM formula to your worksheet is to use AutoSum.
Create a simple formula in Excel On the worksheet click the cell in which you want to enter the formula.
Type the equals sign. To create a formula. Select an empty cell directly above or below the range that you want to sum and on the Home or Formula tabs of the ribbon click AutoSum Sum. Select the cell where you want to put the formula type the equals sign and write the desired function name or choose the function from the suggested function list.