Record a macro whilst sorting the data, it will give you what you need.

At the end add these formulae to a couple of cells

=SUMIF(A:A,"<0")
=SUMIF(A:A,"=0")

it will all be there

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"debra2468 " wrote in message
...
hi all,
i am looking out for a macro code which can sort a column in ascending
order..
i have a column K which contains positive and negative values..i need
to sort this column in ascending order..then i have to display the
grand totals of the positive and negative values by inserting rows and
bold these totals....

can someone please help me out in this ?


---
Message posted from http://www.ExcelForum.com/