Calculating budget spend each month

Posted by Richard Mills on July 16, 2001 4:49 AM

I have a spreadsheet for managing my money and would like to know how to calculate how much I spend each month on a certain budget catagory.

Col A has the full transaction date (year to date)
Col D has the budget category
Col E has the amount

Could anybody suggest a way of doing this.
Cheers!

Posted by Alix on July 16, 2001 6:30 AM

Hi Richard

The formula below will convert the full transaction date to a month / year date. If you add a column with this formula and change the format to month and year you can use a pivot table to subtotal by month and category

=A2-DAY(A2)+1

Alix