Hello.
When I do a basic sort, the total below the sorted column increases by 1. Here are the details.

I have a worksheet with a number of very basic two-column tables on it.
The first column of each table has a name and the second column has a number. Each table has a header.
The tables are not long---range from about 10-20 rows each.
Below the final row of the second column is a sum formula to add the numbers of the second column, so it looks kind of like this (except the "150" is below the number column):

Column A Column B
Header Header
Name A 100
Name B 25
Name C 25
150

The problem is that when I select the entire table (including headers, but not including the sum total below the last row, as noted by blue text above) and sort by Column A, the cell with the formula result increases by one (so in the above example, the total would change to 151). When I look at the formula, the cell references in the formula have not changed.

Any thoughts on where this additional "1" is coming from and how I can stop it?

Thank you.
Andi
Nashville, TN