I've got a simple table (10 columns, 200 rows). The values in the final
column are totalled.

However, this total changes depending on which other column I use to sort
the whole table. (I can get three different values all +/- $100 around
$6000. This would suggest a maximum of two cells are being 'missed'.

The cell references in the total formula have been double-checked and are
accurate. I've set up another cell that sums the column using absolute
addressing. Its total changes on an identical basis.

All formats for cells in the total column have been double checked and are
consistently showing currency.

So I'm at a loss two answer two questions :
- what is the correct total
- why the difference
- how do I resolve it

Any help will be appreciated.

TIA