Sorting problem, sums change

I have a spreadsheet with 12 worksheets. It totals fine the way it is, but
on several of the worksheets I need to sort them by State, when I do, the
totals change. It calls data from one of the other worksheets cells which
remains the same. Once I sort one of the worksheets the data pulling from
the other worksheets now displays
#DIV/0! and my totals are wrong at the bottom. Any suggestions.

Just a thought.
Copy "Values" to another column, and then sort that column, and perhaps hide
the original.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Mychele" <[email protected]> wrote in message
news:[email protected]...
I have a spreadsheet with 12 worksheets. It totals fine the way it is, but
on several of the worksheets I need to sort them by State, when I do, the
totals change. It calls data from one of the other worksheets cells which
remains the same. Once I sort one of the worksheets the data pulling from
the other worksheets now displays
#DIV/0! and my totals are wrong at the bottom. Any suggestions.