[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]Location[/TD]
[TD]Service[/TD]
[TD]Shut-in[/TD]
[TD]Impact[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-08[/TD]
[TD]WL[/TD]
[TD]3/15/16[/TD]
[TD]150 [/TD]
[/TR]
[TR]
[TD]03-08[/TD]
[TD]AL[/TD]
[TD]3/1/15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11-17[/TD]
[TD]WL[/TD]
[TD]3/15/15[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]11-17[/TD]
[TD]WL[/TD]
[TD]3/15/15[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]11-17[/TD]
[TD]AL[/TD]
[TD]3/1/15[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]11-19[/TD]
[TD]WL[/TD]
[TD][/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]11-19[/TD]
[TD]WL[/TD]
[TD][/TD]
[TD]100[/TD]
[/TR]
</TBODY>[/TABLE]
Here's an example of the data I'm working with:
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!
<TBODY>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]Location[/TD]
[TD]Service[/TD]
[TD]Shut-in[/TD]
[TD]Impact[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-08[/TD]
[TD]WL[/TD]
[TD]3/15/16[/TD]
[TD]150 [/TD]
[/TR]
[TR]
[TD]03-08[/TD]
[TD]AL[/TD]
[TD]3/1/15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11-17[/TD]
[TD]WL[/TD]
[TD]3/15/15[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]11-17[/TD]
[TD]WL[/TD]
[TD]3/15/15[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]11-17[/TD]
[TD]AL[/TD]
[TD]3/1/15[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]11-19[/TD]
[TD]WL[/TD]
[TD][/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]11-19[/TD]
[TD]WL[/TD]
[TD][/TD]
[TD]100[/TD]
[/TR]
</TBODY>[/TABLE]
Here's an example of the data I'm working with:
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!