Hi All,

I'm using excel to maintain a database for a BI Dashboard as I thought it would be easiest since most of the data that feeds into this data set is not "flat". I've got most of the data to work but I'm having trouble pulling from a dataset that is a running total and is posted weekly.

Since this data is a running total I need to pull either data for the final week of the period, if the full period is over, or current week, if we are still in that period then based on the matrix in L1:M3

I originally tried using an if, then statements - first, looking if the data is for the current week and pasting if so, if not then max(if) statement with a sumifs looking for matching location/period/year data if the line is the final week of the period, if none of these criteria are met then zero (since the end goal is to sum up the data based on period).


But the data set is for 3 year (1 past, 1 current, 1 future) and contains over 30,000 line items. Whenever I try to paste the if then statement it freezes up excel. I'd appreciate any recommendations on how to tackle this.

Thanks,