ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sum spending and group for each month/category (https://www.excelbanter.com/excel-discussion-misc-queries/230104-sum-spending-group-each-month-category.html)

Roady

Sum spending and group for each month/category
 
Hi:

I have a spreadsheet for my spending. It has columns such as: category,
date, and $ amount. I want to be able to sum all spending by category for
each month. For example, it would auto-calc all Food expenses for May, all
Gas expenses for May, and then do the same for June, etc.

i have tried several combos of SUM, SUMIF, etc. but nothing works.
Recommendations?
Thanks, R


All times are GMT +1. The time now is 11:38 PM.

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