Hey,
Not sure if this is possible, but it'd be greatly helpful if it was.
I am looking for a function (OFFSET or INDEX seem the best bet) that only counts the last n instances of an event if it meets certain criteria.
For Example: Say Column A contains "text" ("Y" and "Z") and Column B contains a value. I'd like a formula that sums the last n instances that Column A contains "Y".
Sample:
A B
Y 18
Z 23
Z 16
Y 18
Y 21
Y 24
Z 27
Z 13
Y 19
Z 15
Say in this example I want the last 3 instances of Y (19+24+21=64) or Z (15+13+27=55), but for it to update when new values of each are added. So, before the final "Y" value was added Y (24+21+18=63).
Any help would be appreciated.
Bookmarks