What I mean by when it is changed is when the number in cell G7 changes (as there is a formula in there which adds up cells on that sheet), then I need the cell in K4 to change also!

And calculation is set to automatic....