Hi all

I have multiple similar autofiltered worksheets in a workbook as like
below.
My goal is calculating Line adherence(LA) and Quantity adherence(QA).
Quantity adherence very simple to me.

QA=SUBTOTAL(9;N3:N789)/=SUBTOTAL(3;N3:N789)
QA:6/8

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

---------------------------------------------

I have array formula for unique items for total line , for this sample
is 3(x1,x2,x3) with ctrl+shft+enter

=SUM(1/MMULT((IF(((M3:M789)=N1);E3:E789)=TRANSPOSE(IF(((M 3:M789)=N1);E3:E789)))+0;ROW(E3:E789)^0))-1

Line is 1 for above sample on column O
x1:1*0*1.......0
x2:1*0*1.......0
x3:1*1.........1
LA:1/3

I couldn't get any formula for column O ?

I appreciate any help given,
thank you.