Add the last 4 rows of a Google sheet column

[mikec29526]

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.

 

[Pabblymember11]

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.

 

[mikec29526]

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?

 

[Pabblymember11]

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.

Signup

connect.pabbly.com

 

[mikec29526]

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!!!