Hi,

If your list is like this

state price
NY 2
NY 33
NY 4
NY 4
NY 5
NY 35
CT 25
CT 32
CT 234
CT 234



then select the whole table then use DAta subtotal to get something
like this
state price
NY 2
NY 33
NY 4
NY 4
NY 5
NY 35
NY Total 83
CT 25
CT 32
CT 234
CT 234
CT Total 525
Grand Total 608

hope it helps.


Elsie wrote:

Hi, I got a column with items and their categories. I need to sum up those
belonging to the same category. I am thinking of looping the column and
comparing the 1st row with the 2nd row, if they are the same, I add them up.

But I don't how to continue from there. Please advise.

Elsie