C
chrismania
I have a big problem:
Have the following 2 Sheets
It is about what is in the salespipeline.
In Jan there are three new Comp. In Feb I could win the contract with
Comp1. Comp2 and 3 are postponed. The numbers say how many days there
are in the pipeline.
Jan Feb
a b c a
b c
Comp1 New 10 Comp1 Won
10
Comp2 New 20 Comp2 23
20
Comp3 New 30 Comp3 15
30
I want to sum the values of companies that are currently in the
pipeline (Comp2 and Comp3).
The result in this case should be 50 (10+20+30-10)
Thanks all of you
Have the following 2 Sheets
It is about what is in the salespipeline.
In Jan there are three new Comp. In Feb I could win the contract with
Comp1. Comp2 and 3 are postponed. The numbers say how many days there
are in the pipeline.
Jan Feb
a b c a
b c
Comp1 New 10 Comp1 Won
10
Comp2 New 20 Comp2 23
20
Comp3 New 30 Comp3 15
30
I want to sum the values of companies that are currently in the
pipeline (Comp2 and Comp3).
The result in this case should be 50 (10+20+30-10)
Thanks all of you