Sum of multple values, dependant on specifc date (within broader dates)

[Naomi2701]

I need to calculate the sum of specific cells, only when the fall within a specific date range. Our data can carry across months- eg Aug 1- Sep 15, however we need to count within a speicfic month only (eg September). I have tried a variety of SUMIFS, but I can't find the magic combination to get me what I need.
Any help would be greatly appreciated. Thanks, Naomi.

 

[Peter_SSs]

Without knowing a bit more about the detail of your data and its layout, it is difficult to advise a specific formula.

Any chance you could post a small set of sample data and the expected results?

 

[Naomi2701]

Thanks very much Peter.

My columns are "Date in" (from D11) and "Date Out" (from E11)- I need to only add days that fall within a specific month. eg 30/8/19- 2/9/19 would be 2 days in August and 2 in September. Can Excel be intuitive enough to split these dates?

I have also included cells to dictate the relevant month (1/9/19, D1), [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=EOMONTH(D1,0) (E1) if they are needed.

Thanks,
Naomi.
[/FONT]

 

[Peter_SSs]

Your thread title says you want to sum multiple values, but your first post says you want to count something.
Are you summing (if so what as I am sure your aren't summing dates) or are you counting?

Remember that you know exactly what your sheet looks like and what you want to achieve, but we only know what you tell us (if we can interpret that correctly) or what you show us. So far I know that you have dates in columns D & E from row 11 and in D1 & E1, but what after that?

To help clarify both what you have and what you want ..

Any chance you could post a small set of sample data and the expected results?

My signature block below has help with how to do that.