Did you turn on the macro recorder and do it manually?

Also, you would need to sort by ID and then Product before you do it to get
the correct subtotals.
--
Regards,
Tom Ogilvy


"mr1104839" wrote:


Keep getting an error message with i try to write a marco to caculate
the subtotal of a items. say i am trying to total the number of sales a
rep has for a product. please see example below and help.
ID Product Item Sales
p1 beh 1745 20
p1 hbe 1742 5
p1 bed 125 10
p1 hbe 172 15
p2 hbe 1742 52

and so on with several defferent ID and products.......any help you
could give would be helpful.


--
mr1104839
------------------------------------------------------------------------
mr1104839's Profile: http://www.excelforum.com/member.php...o&userid=37661
View this thread: http://www.excelforum.com/showthread...hreadid=572716