Dear ALl,
I do have a small sample data set across A1:B10 as follows.
I would like to conditionally sum as per the desired result across C2:C10.
Could somebody help me out with the formula which can yield the same?
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>Thanks
I do have a small sample data set across A1:B10 as follows.
I would like to conditionally sum as per the desired result across C2:C10.
Could somebody help me out with the formula which can yield the same?
Region | Identifier | Desired Result |
A | 1 | 1 |
A | 1 | 2 |
A | 1 | 3 |
A | 1 | 4 |
B | 1 | 1 |
B | 1 | 2 |
B | 1 | 3 |
C | 1 | 1 |
C | 1 | 2 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>