Column A | Column B | Column C | Column D |
Location | Service | Shut-in | Impact |
03-08 | WL | 3/15/16 | 150 |
03-08 | AL | 3/1/15 | |
11-17 | WL | 3/15/15 | 200 |
11-17 | WL | 3/15/15 | 200 |
11-17 | AL | 3/1/15 | 150 |
11-19 | WL | 100 | |
11-19 | WL | 100 |
<TBODY>
</TBODY>
What I would like to do is add the impact in column D only once for each location and service where that location has been shut in. If there is no shut in date (ie the location is still in service) I don't want the impact counted in the total. So to put it another way: I would like Excel to find the total sum of impacts for all shut-in locations without counting impacts from duplicate lines more than once.
With the data above, the correct code would give me 150+200+150=500 (see below)
03-08 WL 3/15/16 150
11-17 WL 3/15/15 200
11-17 AL 3/1/15 +150
500 Total Impact
The actual sheet has many different locations, services and dates. I am POSITIVE there's a simple way of doing this but it's eluding me. If anyone can help I would really appreciate it.
Thanks!