Hello,
I am unable to work out or find a solution online for the following sheet.
I have a number of tasks to complete which are recorded as YES or No, as not all tasks are required for certain products these are recorded as NA. (drop downs)
The problem I face is to adjust the overall percentage of the sheet when NA is recorded, currently these affect the percent compliance if used.
What changes do I need to make for the formula please. I have attached an image.
Many thanks in advance.
=COUNTIF(E2:E13,"Yes")
=COUNTIF(E2:E13,"No")
=COUNTIF(E2:E13,"NA")
=SUM(E14/(B13-E16))
Kind regards
Avistasys
I am unable to work out or find a solution online for the following sheet.
I have a number of tasks to complete which are recorded as YES or No, as not all tasks are required for certain products these are recorded as NA. (drop downs)
The problem I face is to adjust the overall percentage of the sheet when NA is recorded, currently these affect the percent compliance if used.
What changes do I need to make for the formula please. I have attached an image.
Many thanks in advance.
=COUNTIF(E2:E13,"Yes")
=COUNTIF(E2:E13,"No")
=COUNTIF(E2:E13,"NA")
=SUM(E14/(B13-E16))
Kind regards
Avistasys