I am attaching an excel file in which I want to calculate % of missing, % of incorrect and total % of CDE (critical data elements) for my projects.
In the "Totals (May 2019)" sheet for the columns "CDE Missing" and "CDE Incorrect", I want a formula which will calculate only those missing or incorrect entries which are highlighted in yellow (highlighted in yellow are my defined critical data elements). For #missing and #incorrect columns I already have a formula ready which is in this excel. Please help me with this.
Thank you all.
Danish
Bookmarks