I would to make a formula for O column in order to include
results of x1,x2,x3,...
suppose we have a list like that
e3:e789 n3:n789 O3:O789
Drawing no on time delivery
x1 1 0
x1 0
x1 1
x2 1 0
x2 0
x2 1
x3 1 1
x3 1
x4 0 0
o3:n3*n4*n5..........as the result of x1
o6:n6*n7*n8..........as the result of x2
o9:n9*n10.............as the result of x3
o11:n11................as the result of x4
One way:
In P3 put
=N3*IF(E3=E4,P4,1)
and copy down.
In O3 put
=IF(E3=E2,"",P3)
and copy down.
You can hide column P if need be.
|