Hi All,
The desired output column, should be a cumulative figure of the area, the criteria being the summation should happen when the status is Completed & names are of the same tech.
Example:
SJR Tech = 100+200+300 = 600
If the status is Proposed or Under Construction, the output should be area as listed.
Example:
SJR tech 3 = 200 (since status is proposed)
Would really appreciate the help. Thanks
<tbody>
</tbody>
The desired output column, should be a cumulative figure of the area, the criteria being the summation should happen when the status is Completed & names are of the same tech.
Example:
SJR Tech = 100+200+300 = 600
If the status is Proposed or Under Construction, the output should be area as listed.
Example:
SJR tech 3 = 200 (since status is proposed)
Would really appreciate the help. Thanks
A | B | C | D | E | F | |
1 | Status | Name | Area | Desired Output | ||
2 | Completed | SJR Tech 1 | 100 | 600 | ||
3 | Completed | SJR Tech 2 | 200 | 600 | ||
4 | Under Construction | SJR tech 3 | 200 | 200 | ||
5 | Completed | SJR Tech 4 | 300 | 600 | ||
6 | Under Construction | ABC Tech 1 | 200 | 200 | ||
7 | Under Construction | ABC Tech 2 | 300 | 300 | ||
8 | Completed | ABC Tech 3 | 400 | 900 | ||
9 | Completed | ABC Tech 4 | 500 | 900 | ||
10 | Completed | DEG Tech 1 | 600 | 1300 | ||
11 | Completed | DEG Tech 2 | 700 | 1300 | ||
12 | Under Construction | DEG Tech 4 | 300 | 300 | ||
13 | Proposed | FGT Tech 1 | 200 | 200 | ||
14 | Proposed | FGT Tech 2 | 300 | 300 | ||
15 | Completed | FGT Tech 3 | 200 | 400 | ||
16 | Completed | FGT Tech 4 | 200 | 400 |
<tbody>
</tbody>