Sumifs with mid corresponding to the month

Hello Forum Leader,

I have two sheet time and breakup. Am try to apply the sumifs value against of the month column C4(Breakup) but value return wrongly.

=SUMIFS(DATA!$D:$D,DATA!$C:$C,MID(BREAKUP!$B4,1,1),DATA!$A:$A,">="&EOMONTH(BREAKUP!C$3,-1),DATA!$A:$A,"<="&EOMONTH(BREAKUP!C$3,0))

Please help me.

Richard Buttrey

thank you for your reply. return the value is fine for d5 but i need standard formulas for all the cells. why its return wrong value for the specif cells.

please help me.

Change:

=SUMIFS(DATA!$D:$D,DATA!$C:$C,MID(BREAKUP!$B4,1,1),DATA!$A:$A,">="&EOMONTH(BREAKUP!C$3,-1),DATA!$A:$A,"<="&EOMONTH(BREAKUP!C$3,0))

To:

=SUMIFS(DATA!$D:$D,DATA!$C:$C,MID(BREAKUP!$B4,1,1),DATA!$A:$A,">"&EOMONTH(BREAKUP!C$3,-1),DATA!$A:$A,"<="&EOMONTH(BREAKUP!C$3,0))