SUMIFS having dropdownlist of expenses and income by month

[cmine20]

I have a problem with my sumifs I want to sum a specific dropdownlist and sum the whole month this is my code.

C - Amount
B - Dropdownlist (Expensive and Income)
A - Date
E - Months

=SUMIFS(C2:C7,B2:B7,F1,A2:A7,">="&E2,A2:A7,"<="&EOMONTH(E2,0))

please help me with this if there is another alternative I'm In, I'll take that.

 

[arthurbr]

How about making your range an Excel Table and use it as source for a Pivot Table

 

[Peter_SSs]

I think that your formula is close. It depends on exactly what you have in E2 & E3 and you do need some $ signs.
In E2 & E3 put the date for the first day of the month. (If you want, you can then format that column with a custom format of "mmm" and it will look exactly like your screen shot.
Then use the formula shown below, copied across and down.

BTW, you will generally get faster & better responses in the forum if you provide your sample data with XL2BB so that helpers can easily copy for testing.

20 12 25.xlsm
	A	B	C	D	E	F	G
1						Expenses	Income
2	1/01/2021	Expenses	100		1/01/2021	220	300
3	2/01/2021	Expenses	120		1/02/2021	100	400
4	3/01/2021	Income	300
5	1/02/2021	Income	200
6	2/02/2021	Expenses	100
7	3/02/2021	Income	200
Summary

Cell Formulas
Range	Formula
F2:G3	F2	=SUMIFS($C$2:$C$7,$B$2:$B$7,F$1,$A$2:$A$7,">="&$E2,$A$2:$A$7,"<="&EOMONTH($E2,0))