Sum for the last 24

[Howlin]

Hi,

I would like to sum the total number of defects in a column but specifically for the last 24. 24 comes from our cleaning.

The material identifies are WO then a number. So what I would need excel to do is to make the range always end as the last row in the table and the start of the range the last row minus 23(SO 24 rows in total are used) and then sum the number of defects in this range. I've coloured the font in red the rows that I'd like to include.
Excel Query 4.xlsx

Help would be appreciated.

Cheers,

Tom

[zbor]

Put this in B34 and extend to the right

Please Login or Register  to view this content.

[zbor]

If there is no 24 rows you will get error.
This one will use last n rows (1,2,3... etc) up to 24 (but not more).

Please Login or Register  to view this content.

[Howlin]

Works that is great! Thanks.