Hi Excel Experts,
I need to customise the Sumif formula here...if you look at the below table..typical sumif will give the require numbers however, I should get the sumif results at once not at every line where we have same lines....for example below
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
Can anyone help me on this...
I need to customise the Sumif formula here...if you look at the below table..typical sumif will give the require numbers however, I should get the sumif results at once not at every line where we have same lines....for example below
EMP ID | Amount | Actual Sumif | Require Output |
11111 | -950 | 100 | 100 |
11111 | 950 | 0 | 0 |
33333 | 698 | 0 | 0 |
33333 | -698 | 0 | 698 |
44444 | 650 | 0 | 0 |
55555 | 250 | 0 | 0 |
44444 | -650 | 0 | 650 |
55555 | -250 | 0 | 250 |
11111 | 100 | 0 | 0 |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
Can anyone help me on this...