I'm trying to create a formula that can sum a range of data based on multiple conditions and be dynamic to change the time period criteria because I'm using this to calculate month-to-date information, which I will need to change periodically. I need a formula that I can easily change certain criteria because this will be a very large report.
I have the following formula:
=SUMIFS('[Weekly Report Data Drop.xlsm]Actuals'!$H$4:$H$59793,'[Weekly Report Data Drop.xlsm]Actuals'!$E$4:$E$59793,$A$6,'[Weekly Report Data Drop.xlsm]Actuals'!$D$4:$D$59793,$A$7,'[Weekly Report Data Drop.xlsm]Actuals'!$C$4:$C$59793,$A2,'[Weekly Report Data Drop.xlsm]Actuals'!$M$3:$M$59793,">="&T2,'[Weekly Report Data Drop.xlsm]Actuals'!$M$3:$M$59793,"<="&T3)
The last two conditions with the >= and <= seem to be causing the formula to error out, the working was working before I ended those last
I can't get a sample to a small enough file size to attached, but cell T2 and T3 contain dates so 8/1/2014 in T2 and 8/16/2014 T3
Bookmarks