I require specific formula for lot wise sum of ID .
The ID will re-occur but the re-occurred ID should be separately addition-ed.
The ID will be nearly in 2000 number.
# Do not sum all the similar Structure ID
#Do not change the Structure ID
<tbody>
</tbody>
The ID will re-occur but the re-occurred ID should be separately addition-ed.
The ID will be nearly in 2000 number.
# Do not sum all the similar Structure ID
#Do not change the Structure ID
Structure ID | Weight | SUM |
A | 1 | |
A | 1 | 3 |
B | 2 | |
B | 3 | 5 |
G | 3 | |
G | 4 | 7 |
A | 5 | |
A | 6 | 11 |
B | 7 | |
B | 6 | 13 |
R | 4 | |
R | 3 | 7 |
G | 2 | 2 |
<tbody>
</tbody>