Forum Discussion
Trying to Sum Expenses by Current Month
Hello, I created a budget spreadsheet for myself and I want to sum only the current month's actual expenses. My current equation looks like this for my actual expenses: =SUMIFS(J:J,H:H,M7,I:I,...
Hi K8Bug
Formatted your data as Table (recommended) named Table1 and added a couple of dummy info:
in O7 Total of Subscriptions for current months:
=SUMIFS(Table1[Amount],
Table1[Description], M7,
Table1[Date],">=" & E3,
Table1[Date],"<" & EDATE($E$3,1)
)
Lorenzo I reformatted everything so they would be actual tables and plugged in your equation and it worked perfectly!
Thank you so much. I've been trying to figure that out for about a month on and off.