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?
[TABLE="width: 226"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Region[/TD]
[TD]Identifier[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 226"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Region[/TD]
[TD]Identifier[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Thanks