Date Range Based Sumifs...

Here's what I've been trying to do...

Sheet 1 has dates in column A for all the working days in a month. The other columns B onwards until AL have data, and I need to use this data depending upon the required criteria to populate sheet 2.

Sheet 2 has the working weekdays (start date and end date) in Column A2 & B2. In other words, if a Monday is on June 4(Column A) and Friday is June 8(Column B) , then I should be able sum (using Sumifs function) the data in sheet 2 for all items that are in sheet 1 in columns C3, D3 etc... within that date range (June 4-8), and similarly for the next week (June 11 cell A3 and June 15 cell B3, and so on for the remaining 2 weeks....

Hope this makes sense of what I'm trying to get at...

Please advise your thoughts...

Thanks for a prompt response, I really appreciate your help!

The formula looks alright, but as I need to use this across 2-3 sheets,it may get more complex with few criterias in place. Do you think there is a simpler one that can be used?

One other limitation is that my data is quite large, and I cannot introduce any additional columns

=_xlfn.SUMIFS($B$2:$B$8,$A$2:$A$8,">="&A13,$A$2:$A$8,"<="&B13)

Please advise your thoughts...

Thanks a ton in advance!

Thanks Dennis,

I'm not at my desk at this point so will take a look asap, and seek your advice.

For now, just one query:

Can I substitute the SUM in your formula with SUMIFS, as I'll have multiple criteria's to sum?

As far as my data sheet is concerned, I'll definitely upload one. However, it is exactly as the one you uploaded in the first instance. The only 2 differences are:

1) My data is in one sheet for the working days in a week. Some columns have text data, that forms the basis of the criteria
2) The week date ranges for which the sum is to be extracted is in a seprate sheet

Thanks for your immense help on this!

If this works as per my needs. It will surely be a great tool to cut down mannual effort!

You're a Rock Star

Best regards.

Thank you Dennis!

This along with some minor tweaks in my data set worked superbly!

My apologies for not getting back a bit. earlier than this...

You are a magician!

Look forward to stay connected!

I'll mark this as solved (courtesy) you:-)

Thanks much!

True!

Learned -> Executed/Implemented -> Succeeded!

Cheers!!!