sum date help

[MCB123x]

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)

 

[skillilea]

When you say trigger, do you mean calculate?

If your worksheet is set to automatic the above SUMIFS will calculate on worksheet changes.

Formulas/Calculation Options / Automatic

 

[MCB123x]

yes, i meant calculate.

If automatic is the default then thats what it is set to. Don't wanna change that for this one date sum. no worries. I'll just have to type the date manually
Thank you

 

[skillilea]

Maybe I'm confused. Great if the sheet is on Auto Calc, that is the default.

What date are you trying to programmatically have inputted?

 

[MCB123x]

the cell C5 is a date cell set at (feb 1, 2024). when that date rolls around I need the formula to 'activate' pulling the value from B11 into the cell the formula sits in

 

[skillilea]

You can set the value on workbook Open. Go to "ThisWorkbook" and add this code it will change the date in cell C5

Private Sub Workbook_Open()
    ChangeDateInProductionSheet
End Sub


Private Sub ChangeDateInProductionSheet()
    Sheet1.Range("C5") = Date
End Sub

if this is not what you are looking for, please post your worksheet.

 

[MCB123x]

Thankyou