Sort function won't work with copied sum totals
 

I have a worksheet with 12 columns of names and one row of months. See
example 1. I want to create a running total of the highest accumulated
sales. See example 2.

I copied and pasted the name and sums to a new area of the worksheet and it
worked fine. But when I try to sort into highest to lowest I get all $0.00
instead of actual accumulated totals.

I am an extreme novice when it comes to Excel, as you can see. Any help
would be appreciated.

Thanks in advance,

Julie
Example 1
Julie Christine Heather Tara Melissa Dawn
Jan-08 $500.00 $0.00 $0.00 $0.00 $0.00 $200.00
Feb-08 $200.00 $300.00 $100.00 $0.00 $0.00 $0.00
Mar-08 $0.00 $100.00 $200.00 $0.00 $0.00 $0.00
Apr-08 $0.00 $200.00 $300.00 $0.00 $0.00 $0.00
May-08 $100.00 $0.00 $100.00 $400.00 $0.00 $100.00
Totals $800.00 $600.00 $700.00 $400.00 $0.00 $300.00


Example 2
Julie $800.00
Heather $700.00
Christine $600.00
Tara $400.00
Dawn $300.00
Melissa $0.00

Sort function won't work with copied sum totals
 

With data in the range A1:G7, select B7:G1 then click Data Sort Sort By Row
7 Descending Options Left to Right Ok.

Regards,
Ryan---

--
RyGuy


"JulieInFlorida" wrote:

I have a worksheet with 12 columns of names and one row of months. See
example 1. I want to create a running total of the highest accumulated
sales. See example 2.

I copied and pasted the name and sums to a new area of the worksheet and it
worked fine. But when I try to sort into highest to lowest I get all $0.00
instead of actual accumulated totals.

I am an extreme novice when it comes to Excel, as you can see. Any help
would be appreciated.

Thanks in advance,

Julie
Example 1
Julie Christine Heather Tara Melissa Dawn
Jan-08 $500.00 $0.00 $0.00 $0.00 $0.00 $200.00
Feb-08 $200.00 $300.00 $100.00 $0.00 $0.00 $0.00
Mar-08 $0.00 $100.00 $200.00 $0.00 $0.00 $0.00
Apr-08 $0.00 $200.00 $300.00 $0.00 $0.00 $0.00
May-08 $100.00 $0.00 $100.00 $400.00 $0.00 $100.00
Totals $800.00 $600.00 $700.00 $400.00 $0.00 $300.00


Example 2
Julie $800.00
Heather $700.00
Christine $600.00
Tara $400.00
Dawn $300.00
Melissa $0.00