Sum Scripts added with the past week formula
I need help identifying a formula. When the Timing, Affected Environment(s) and Script Type match, identify the Execution Date within the past 7 days and calculate the difference between Total Executed to update the Added in last week. In the example below, this formula circled in red should return '0'. Since Timing, Affected Environment(s) and Script Type match, and their is an Execution Date in the prior 7 days, the difference between the Total Executed of those rows is '0'.
I know I need to start with 'SUMIF' but I'm confused how to thread in the prior 7 day date logic. Thanks for the support.
Help Article Resources
Check out the Formula Handbook template!