Sum last n rows

Lcoulthard

Does anyone know how to write a formula that will sum up the last four rows only?

Example- The GPO Volume dollar amount gets populated each quarter.

I would like a formula that would remove row 11 and add in row 15 once the value is in there so I can only show the last 4 quarters total volume.

Thanks in advance!

Paul Newcome

Try something along the lines of

=SUMIFS({GPO Volume}, {Distribution Date}, @cell>= LARGE(COLLECT({Distribution Date}, {GPO Volume}, @cell <> ""), 4))

Lcoulthard

Thank you for the response! I couldn't get that to work. I'm thinking it's something with the ,4)) at the end.

I keep getting #UNPARSEABLE.

Paul Newcome

The formula has the proper syntax. Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?