Hi Mark Just put =A2 in the total cell (for your example). That will always return the sum of the values in that column.