Hello. This is the formula. What I need it to also do is trigger when the new month rolls around. Right now it triggers when a date in entered into the B column, which is what I need but I also would like to see it trigger automatically. Can this be done? Thanks in advance.
=SUMIFS($D$16:$D$71, $B$16:$B$71, ">="&C5, $B$16:$B$71, "<="&EOMONTH(C5, 0)) + IF(SUMIFS($B$16:$B$71, $B$16:$B$71, ">="&C5, $B$16:$B$71, "<="&EOMONTH(C5, 0), $D$16:$D$71, "<>"&"") > 0, B11, 0)
=SUMIFS($D$16:$D$71, $B$16:$B$71, ">="&C5, $B$16:$B$71, "<="&EOMONTH(C5, 0)) + IF(SUMIFS($B$16:$B$71, $B$16:$B$71, ">="&C5, $B$16:$B$71, "<="&EOMONTH(C5, 0), $D$16:$D$71, "<>"&"") > 0, B11, 0)