Add the last 4 rows of a Google sheet column

Is it possible to get the last 4 rows of a column in a Google sheet, and add those values up for a total? They are simple integers, like 13, 543, 17, 2489, etc.

Hey @MikeC

You can refer to the following screenshot on your concern, please check that out and let us know if that works for you.

This is helpful, but what happens if I don't know how many rows the sheet has? Each week a row gets added, and I want the monthly total every 30 days, so just the last 4 rows. Over time, the sheet will keep growing in rows. that is why I was wondering if possible to just get the last 4?

This is helpful, but what happens if I don't know how many rows the sheet has? Each week a row gets added, and I want the monthly total every 30 days, so just the last 4 rows. Over time, the sheet will keep growing in rows. that is why I was wondering if possible to just get the last 4?

Please refer to the following workflow for your concerning use case, kindly give it a try and let us know if that works for you.

https://connect.pabbly.com/workflow/share/DkZQYgVSAmFSGANpBEcMKw4aAgYFXARlVk8CEFVaAnpSH1YtUBEOZA5CVXdSGQNiBUwIYgdbAjhfS1BUAlQDcAMOVHsBHgBdUGNTFlcIDyUObA##

This works incredibly well!!! This is an amazing template you sent me that I customized just a little bit. That arrays feature you sent is great! Thank you so much for the great support!!!