Update formula results
As the picture shows, when the value in cell C4 changes, Excel automatically updates the February total in cell C7 from 126.93 to 130.92.
Excel can do this because the original formula =SUM(C3:C6) in cell C7 contains cell references.
If you had entered 11.97 and other specific values into a formula in cell C7, Excel would not be able to update the total. You’d have to change 11.97 to 15.96 not only in cell C4, but in the formula in cell C7 as well.