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.

Name	Interim	$ interim	Final	Final $
Ada339	Lvl 1	10000	Lvl2	5000
plshelp	Lvl 3	40000	lvl 4	15000
srslyhelp	Lvl2	20000	lvl 4	10000

<tbody>
</tbody>

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