Sumif with min() criteria

[excelhjalp]

Hi!

I'm trying to do sumif function that calculates sum of the first column within a given month. So here I would like to find out the sum of the first column within november, so the criteria would be the stated date, or 30.11.22, whichever's the smallest. Is there a magic solution? I'd prefer not to make a dummy column.

Thanks! :D

 

[Fluff]

How about

=SUMIFS(R39:R44,Q39:Q44,">="&DATE(2022,11,1),Q39:Q44,"<"&DATE(2022,12,1))

 

[excelhjalp]

How about

=SUMIFS(R39:R44,Q39:Q44,">="&DATE(2022,11,1),Q39:Q44,"<"&DATE(2022,12,1))

Hi Fluff! And thank you kindly for your brilliant answer! It works very well!
Would you be able to come up with a solution if I make the problem slightly more difficult? In this scenario I want to find the total number of days within each month based on two date columns. I think sumifs might work but am not sure if I'm correct. Can you think of a formula for that?
So for October in the first date range there would be 14, in the second there would be 14 but in the third there would be 30.11.22-20.11.22 which is 10 etc..

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks

 

[excelhjalp]

As this is a totally different question, it needs a new thread. Thanks

Sure thing. Thanks again for your help Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.