Good mornign to all,
I am trying to sum the last 6 rows in a continuously growing table when a specific name in a different column (letters column) is met.
In the below example I would like to sum lets say the last 2 entries when the letter in the first column is C.
I can get the last 6 rows results with the below function but I can not apply SUMIF or anything like it to filter the data when a criteria is met.
Any help is very much appreciated.
=SUM(OFFSET(A1;MATCH(1E+30;A:A)-1;0;-6;1))
<colgroup><col><col></colgroup><tbody>
</tbody>
I am trying to sum the last 6 rows in a continuously growing table when a specific name in a different column (letters column) is met.
In the below example I would like to sum lets say the last 2 entries when the letter in the first column is C.
I can get the last 6 rows results with the below function but I can not apply SUMIF or anything like it to filter the data when a criteria is met.
Any help is very much appreciated.
=SUM(OFFSET(A1;MATCH(1E+30;A:A)-1;0;-6;1))
A | 5 |
B | 4 |
C | 3 |
A | 3 |
B | 4 |
C | 5 |
A | 5 |
B | 4 |
C | 3 |
A | 3 |
B | 4 |
C | 5 |
<colgroup><col><col></colgroup><tbody>
</tbody>