Trying to Sum Expenses by Current Month

Question

Hello,&nbsp;I created a budget spreadsheet for myself and I want to sum only the current month's actual expenses.&nbsp;My current equation looks like this for my actual expenses:=SUMIFS(J:J,H:H,M7,I:I,"&gt;="&amp;MONTH($E$3),I:I,"&lt;"&amp;EDATE($E$3,1))&nbsp;the E3 here references a cell that displays the current month that has the following equation:=EOMONTH(today(),-1)+1&nbsp;However I'm still seeing it calculate the sum of everything I've entered, not just the current month.&nbsp;I've tried to figure out a SUMPRODUCT equation but haven't been able to get any to work for me.&nbsp;&nbsp;The table below is what I'm currently working with for reference.&nbsp;ABCDEFGHIJKLMNOPQ&nbsp;8/1/2024$ 725.82$ 736.82$ (11.00)&nbsp;CampfireSubscriptions9/30/2024$ 4.25FALSE&nbsp;Car$ 250.00$ 62.50$ 299.59$ (49.59)&nbsp;8/8/2024$ 742.08$ 793.63$ (51.55)&nbsp;Car InsuranceInsurance9/28/2024$ 118.99FALSE&nbsp;Rent$ 99.95$ 24.99$ 199.90$ (99.95)&nbsp;8/15/2024$ 784.06$ 796.99$ (12.93)&nbsp;AppleSubscriptions9/22/2024$ 2.99FALSE&nbsp;Loan$ 100.00$ 25.00$ 100.00$ -&nbsp;8/22/2024$ 770.04$ 786.58$ (16.54)&nbsp;SpotifySubscriptions9/21/2024$ 19.99FALSE&nbsp;Food$ 400.00$ 100.00$ 407.07$ (7.07)&nbsp;8/29/2024$ 769.52$ 603.95$ 165.57&nbsp;SutterMedical9/21/2024$ 50.00FALSE&nbsp;Self Care$ 200.00$ 50.00$ 402.88$ (202.88)&nbsp;9/6/2024&nbsp;$ 400.00$ (400.00)&nbsp;HairSelf Care9/17/2024$ 110.00FALSE&nbsp;Cats$ 100.00$ 25.00$ 399.01$ (299.01)&nbsp;I appreciate any advice!

lorenzo · Answer

Hi&nbsp;K8Bug&nbsp;&nbsp;Formatted your data as Table (recommended) named&nbsp;Table1&nbsp;and added a couple of dummy info:in&nbsp;O7 Total of Subscriptions for current months:=SUMIFS(Table1[Amount],
  Table1[Description], M7,
  Table1[Date],"&gt;=" &amp; E3,
  Table1[Date],"&lt;" &amp; EDATE($E$3,1)
)&nbsp;

k8bug · Answer

Lorenzo&nbsp;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.

lorenzo · Answer

You're welcome&nbsp;K8Bug&nbsp;At the bottom of each reply you get here there's&nbsp;Mark as response link. Clicking it helps people who Search - Thanks

Forum Discussion

Trying to Sum Expenses by Current Month

3 Replies

Resources

A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
	8/1/2024	$ 725.82	$ 736.82	$ (11.00)		Campfire	Subscriptions	9/30/2024	$ 4.25	FALSE		Car	$ 250.00	$ 62.50	$ 299.59	$ (49.59)
	8/8/2024	$ 742.08	$ 793.63	$ (51.55)		Car Insurance	Insurance	9/28/2024	$ 118.99	FALSE		Rent	$ 99.95	$ 24.99	$ 199.90	$ (99.95)
	8/15/2024	$ 784.06	$ 796.99	$ (12.93)		Apple	Subscriptions	9/22/2024	$ 2.99	FALSE		Loan	$ 100.00	$ 25.00	$ 100.00	$ -
	8/22/2024	$ 770.04	$ 786.58	$ (16.54)		Spotify	Subscriptions	9/21/2024	$ 19.99	FALSE		Food	$ 400.00	$ 100.00	$ 407.07	$ (7.07)
	8/29/2024	$ 769.52	$ 603.95	$ 165.57		Sutter	Medical	9/21/2024	$ 50.00	FALSE		Self Care	$ 200.00	$ 50.00	$ 402.88	$ (202.88)
	9/6/2024		$ 400.00	$ (400.00)		Hair	Self Care	9/17/2024	$ 110.00	FALSE		Cats	$ 100.00	$ 25.00	$ 399.01	$ (299.01)