formula to link cells

[Ada339]

Hello!

Basically,

i have a list of customers, each customer is broken up into two parts (interim and final)

i also have a cell that counts all data for the next 12 months, including interim and final for each. e.g. 15 customers = 30

sometimes we lose a customer to a competitor during the interim stage. i would like a formula that will also remove the customer in the final stage if this happens.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Interim[/TD]
[TD]$ interim[/TD]
[TD]Final[/TD]
[TD]Final $[/TD]
[/TR]
[TR]
[TD]Ada339[/TD]
[TD]Lvl 1[/TD]
[TD]10000[/TD]
[TD]Lvl2[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]plshelp[/TD]
[TD]Lvl 3[/TD]
[TD]40000[/TD]
[TD]lvl 4[/TD]
[TD]15000[/TD]
[/TR]
[TR]
[TD]srslyhelp[/TD]
[TD]Lvl2[/TD]
[TD]20000[/TD]
[TD]lvl 4[/TD]
[TD]10000[/TD]
[/TR]
</tbody>[/TABLE]








so the total for the next 12 months would be 6. If we lost Ada339 to a competitor during the interim (entered manually) that would bring the total for the next 5 months to 5, i would like a formula that will remove the final package too (automatically) bringing the count to 4.

for the dollar amount too.

i'm so sorry if this isn't clear. (it's so hard to summarize a 5,222KB excel file)

Thanks Ada339