how to generate report based on adding costs of particular category

Trish in Oz
-------------
A problem well defined is a puzzle half solved

If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments