Index/Match with Multiple Criteria (Non-Array)

[danhenshy23]

Hi,

I have a large set of data (50k+ rows) which contains staffed hours at 30 minute intervals for 3 different locations. What I am wanting to achieve is a total number of staffed hours for each 30 minute interval. (combining the 3 sites)

So far I have tried SUMIFS (=sumifs(Staffed Hours, Time Interval Range, Time Interval, Date Range, Date) and an array Index/Match formula with multiple criteria, however as the formula is to be replicated 17,000, both approaches have made the file unusable.

Is there a way I can use a non-array Index/Match formula, with multiple Criteria, as I think this might solve the problem.

Thanks
Dan