ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create a list of costs and get subtotals of each category (https://www.excelbanter.com/excel-discussion-misc-queries/74296-how-do-i-create-list-costs-get-subtotals-each-category.html)

Nadz

How do I create a list of costs and get subtotals of each category
 
Im trying to organise a list of costs that our business has month by month.
This i have done using 12 sheets (months) and colums to list the items with
their date and cost. So i can see total outgoings each month. However, i
would like to be able to categorise these costs (eg Postal costs, Utility
Bills, etc) to find out the monthly total spend on each category. I am having
trouble creating a drop down list of categories to select for each entry and
then working out (once thats done) how to get subtotals of the items in
particular categories. Any help or suggestions would be much appreciated!


All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com