Hi
I've tried looking around but I can quite find a formula to meet my needs. What I want is for the formula to sum column B using the last 3 occurrences of a value set in D1 using column A (PERSON).
So for example if I was to use Alice , using the data below the sum of Alice would be 85 (16,49,20).
I would like the formula to work its way up from the last entry as this data will grow
I've posted a table below, had to use the table only method as other option is freezing my excel.
I've tried looking around but I can quite find a formula to meet my needs. What I want is for the formula to sum column B using the last 3 occurrences of a value set in D1 using column A (PERSON).
So for example if I was to use Alice , using the data below the sum of Alice would be 85 (16,49,20).
I would like the formula to work its way up from the last entry as this data will grow
I've posted a table below, had to use the table only method as other option is freezing my excel.
PERSON | AMOUNT |
ALICE | 11 |
TREVOR | 50 |
TREVOR | 18 |
BECKY | 28 |
IAN | 14 |
TREVOR | 33 |
DAVID | 25 |
BECKY | 45 |
TREVOR | 27 |
ALICE | 20 |
IAN | 5 |
TREVOR | 49 |
DAVID | 17 |
IAN | 47 |
BECKY | 34 |
BECKY | 28 |
DAVID | 17 |
ALICE | 49 |
BECKY | 34 |
DAVID | 38 |
IAN | 17 |
TREVOR | 29 |
ALICE | 16 |
IAN | 42 |
IAN | 48 |