In excel 2013, I have 5 columns where there needs to be a summary of the amounts
in that column. The requirement is that the summary amounts always have to be
the final value of that column. The summary line
for all 5 rows will always be the same. The problem is detail row lines may be
deleted and/or inserted. This makes the final summary be able to move.

Due to this circumstance, is there a way to allow the summary line to:
a. always display the correct values, and
b. move in a worksheet that is protected?

If so how would I accomplish this goal? If not. do I have any alternatives
and/or workarounds and what would those alternatives are workarounds be?