a Pivot table does that.

HTH. Best wishes Harald

"maisy1" skrev i
melding ...

How do I get excel to group together certain codes. eg. say some things
came under the code 34567 and there was a value to that code like £30.
how do I get a summary on the sheet to say how much has been spent
under code 34567. The code has a deicated column, with different codes
in the same column.


--
maisy1
------------------------------------------------------------------------
maisy1's Profile:
http://www.excelforum.com/member.php...o&userid=37157
View this thread: http://www.excelforum.com/showthread...hreadid=568786