I have a growing table from A:Bl. It grows by rows, not columns. I am try to write a xlookup formula that will search column D and find the last three occurrences of English
- and return those 3 rows from column E:Bl
- instead of returning the three separate rows of values. I would like one row returned that would have the the sum the 3 rows
ex. English – 5 – 5 – 5…
instead of:
English – 2 – 2 – 2…
English – 2 – 2 – 2…
English – 1 – 1 – 1…
I have tried this:=XLOOKUP(SEQUENCE(3), ROW(D2:D), INDEX(FILTER(E2:BL, D2:D=”English”), ), , -1)
It doesnt work… I am looking for a formula and not app script