Sorting problem, sums change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
==============================================

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum multiple sheets? 1
Sorting in multiple worksheets 1
auto sort macro 1
copying cell contents from one worksheet to another (re-sorted lis 2
Formatting Cell that displays sum from other worksheets 3
Excel Excel Formula OFFSET maybe? 1
using data from one worksheet in another worksheet 1
Excel 2003 Sum question 2

Back
Top