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...