Hi - I have 2 coloumns of mixed data, 1 with values and 1 with a
catergory code. I would like to summarise the data, ie I may have 50
items of catergory "STK" but would like to know the total value. The
aim is to have 2 sheets in excel, 1 as a summary page, the other as the
data sheet.

What formulae would I use please?


--
danuk2006
------------------------------------------------------------------------
danuk2006's Profile: http://www.excelforum.com/member.php...o&userid=36522
View this thread: http://www.excelforum.com/showthread...hreadid=562742