Short-hand method for using the multi-row formula tool across many rows

[AndrewVogel]

I would like to sum only the previous 20 rows of each data entry. Is there a way to write this expression quickly (excel's range approach comes to mind i.e. SUM(A1:A19)). At the moment my only though is to type out the entire expression of: [Row-19:Field] + [Row-18: Field] + .... + [Row-1: Field] + [Field].

Thanks all

[atcodedog05 · Accepted solution]

Hi @AndrewVogel 

The answer is no there is not 😅. Maybe you can use summarize tool get sum of those rows 🙂

[AndrewVogel]

Thanks for clarifying @atcodedog05 ... Let's hope my requirement stays manageable around 20 and not like 200!!

Cheers

[atcodedog05]

@AndrewVogel  yup hopefully

Happy to help : )

Cheers and have a nice day!