SUMIF does not return sum value

[jodipy]

Trying to calculate the monthly volume with sumif but the result still shows 0.
Anyone can help?

Capture.PNG

[JohnTopley]

You appear to be comparing a date (dd/mm/yy) with a month (10) so it will never match.

Try

=SUMIFS(C4:C7,A4:A7,">=" &DATE(YEAR(TODAY()),$B$1,1),A4:A7,"<=" &EOMONTH(DATE(YEAR(TODAY()),$B$1,1),0))

or better

put 01/10/2017 in B1

format as "m"

=SUMIFS(C4:C7,A4:A7,">=" &$B$1,A4:A7,"<=" &EOMONTH($B$1,0))

[Olly]

Or you could use:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[Olly]

Or even simpler:

Please Login or Register  to view this content.

[jodipy]

Thank you for the explanation Olly and JohnTopley. Both method works.

I'ver tried using the method intro by this web but it didn't work. Any idea why my my initial method doesn't work? date issue?

[AliGW]

John explained why in post #2.