Mychele

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How come some worksheets automaticly change sums and others don't.	T.D.	Excel Discussion (Misc queries)	2	January 29th 05 08:41 PM
Sorting problem	JC	Excel Discussion (Misc queries)	3	January 28th 05 03:27 AM
Difficult Sorting Problem	Rob	Excel Discussion (Misc queries)	2	January 5th 05 03:05 PM
Sorting problem	Klaus	Excel Discussion (Misc queries)	3	December 4th 04 01:55 AM
Problem with Sum of Sums in Excel	JB227	Excel Worksheet Functions	1	October 29th 04 03:13 AM

All times are GMT +1. The time now is 09:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us