SUMIFS Column by Date Range

[JohnZ1156]

Good Morning,
I made a simple table for this question. The 1st day of each month, and an amount for that month.
The amount isn't deposited until the first day of the next month.
I'm trying to use the SUMIFS function to show me a yearly total based on the end date.
So, technically, January's amount will be zero until Feb. 1st.
If I enter 3/28/2023 as an end date, it shows me the total for the first 2 months, since the March deposit will not occur until April 1st.

Problem is, when I enter 3/29/2023 as an end date, it's summing in the amount for March which will not exist until April 1st.

 

[Fluff]

For the last criteria use

EOMONTH(F3,-1)

 

[JohnZ1156]

For the last criteria use

EOMONTH(F3,-1)

Thank you Fluff.
I forgot about EOMONTH()

 

[Fluff]

You're welcome & thanks for the feedback.