What is wrong with this SUMIF?

I do not understand why the sumif formula here will not work.

Can someone explain it to me and what the alternative is?

Thanks

Try this ...

=SUMIFS($J$5:$J$25,$I$5:$I$25,">="&--("1"&B5&A5),$I$5:$I$25,"<"&EDATE(--("1"&B5&A5),1))

Or:

=SUMPRODUCT(--(TEXT($I$5:$I$25,"mmmmyyyy")=$B$5&$A$5),$J$5:$J$25)

I do not have SUMIFS but the second one works! Thanks!

What is the double minus mean again?

note: I still do not understand why the formula I wrote won't work...

=SUMIF($I$5:$I$25,AND(YEAR(I5)=$A$5,TEXT(I5,"mmmm")=$B$5),$J$5:$J$25)

The AND condition simply returns a value OF TRUE which of course does not match your dates

Got it! Thanks!

Can the desired result be accomplished using sum(index where the [--AND(YEAR(I5)=$A$5,TEXT(I5,"mmmm")] is 1? (TRUE converted to 1 by the double negative).

If yes, how?