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

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

Expression

Accepted answers

Hi @AndrewVogel

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

All comments

Hi @AndrewVogel

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

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

Cheers

@AndrewVogel yup hopefully

Happy to help : )

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

Hollingsworth 335