I need an advice.
I have a template which can link a cell value to an Excel drop down list as attached.
1. My question is how am i going to count the quantity? I put "?" mark in D28 since we will choose different project under column B which makes the values in "type of test" column is not fix.
2. How can I deduct total value in D28 when I choose "completed" from drop down list in "Status".
Thanks in advance.