How To Put Excel Sum Formula Complete Guide

And then you can use the ROW and INDIRECT functions as demonstrated above and refer to a cell containing the variable cell E1 in our case. As you can see in the formula bar this result is a figure and not a formula. The OFFSET formula will return the range B2B6 and subsequently the SUM function will sum up the values in the range 50 100 150 200 250 and return the value 750.

Now just press Enter and you are done.

When you click AutoSum Excel automatically enters a formula that uses the SUM function to sum the numbers. For example to sum the cost of apples bananas and kiwis only you can use a formula like this. You can start by opening an Excel spreadsheet and selecting an empty cell. The OFFSET formula will return the range B2B6 and subsequently the SUM function will sum up the values in the range 50 100 150 200 250 and return the value 750.