| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum by category, by month | Excel Worksheet Functions | |||
| How to add amount to a cell based on category and month | New Users to Excel | |||
| Group by Month in Pivot-table | Excel Discussion (Misc queries) | |||
| PivotTable Group by Week and Month | Excel Discussion (Misc queries) | |||
| Group by Month when no data | Excel Worksheet Functions | |||
Linear Mode
