Multi-Row Formula summing multiple rows based on criteria

[csh8428]

I have a data-set where I'm trying to create a running total based on a set of criteria(sample attached).

For each grouping of columns A-E, sum [STATUS_LENGTH_DAYS_c] from that row down if [EXP_DT] is within 365 days of that row's [EXP_DT] . Looking at the formula's in the attached spreadsheet makes more sense than a way I can explain it through text.

For example: The first row has an [EXP_DT] of  2024-12-31. The [RunningTotal_12MonthsBack] field would sum all [STATUS_LENGTH_DAYS_c] where all [EXP_DT] is between 2024-12-31 and 2024-01-01 for that aggregated grouping of columns A-E. The expected results are in column J.

The colored bar show the first 3 Results and the range of the calcs as a sample.

Thanks for any help!!

-Craig

[CoG · Accepted solution]

Multi-Row Formula Tool is not going to work for you in this case. The Generate Rows Tool, however, will generate all valid dates for this problem, that you can add a Join criteria prior to a Summarize Tool that will sum up the [STATUS_LENGTH_DAYS] field: