Matching two cells provide Qty

[seansr]

I should be able to work this out but failing miserably

I have provided an example and a description
if v (Status is In Progress) and E is (Client owned) in x (Client owned Tills) and Y (Client owned Printers put in F(Qty)
otherwise it would be zero

V could be Completed, Hold, Place Holder, cancelled
E could be types of Jobs
x & y would always be the same

 

[ETAF]

something like
in X2 and copy down
=IF(AND(V2="in progress",E2="client owned"),F2,0)

Not sure what to put in Y

BUT , not sure how i see Tills v printers
E is type of Till
where are printers ?

 

[seansr]

Brilliant many thanks
FYI printers and tills are on a 1-2-1 relationship

 

[ETAF]

not sure i understand , in the data