help with this SUMIF formula (for a budget spreadsheet)

[boxhamster]

Hi,

I can't seem to figure out what the mistake is.
I want to sum up the amounts depending on the type of expense and the month.

[TABLE="class: grid, width: 395"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Item[/TD]
[TD]Category[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]28.02.2018[/TD]
[TD]Food[/TD]
[TD]Food Shopping[/TD]
[TD] 10,00 €[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Month[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Food Shopping[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Using this formula:
[TABLE="width: 114"]
<tbody>[TR]
[TD]= SUMIFS(D1:D3;MONTH(C1:C3);B4;C1:C3;B5)[/TD]
[/TR]
</tbody>[/TABLE]

Any idea what's going on?

Thanks

 

[steve the fish]

SUMIFS requires ranges so you cant do MONTH(C1:C3). Try this:

=SUMIFS(D1:D3,C1:C3,A5,A1:A3,">="&DATE(YEAR(TODAY()),B4,1),A1:A3,"<"&DATE(YEAR(TODAY()),B4+1,1))

 

[Kaper]

For sure not MONTH(C1:C3)
but (if at all then): MONTH(A1:A3)

Moreover the formula shall be probaly commited as array formula (with Ctrl+Shift+Enter , not just Enter)

 

[boxhamster]

Thank you @steve the fish and @Kaper.

I was able to get it working with your help.