I have a spreadsheet with two tabs. One is labeled "MAIN" and the other is labeled "Appraisal_Status".
On the MAIN tab in Col A7 I have "Appraisal Assessment and Rating Status" and there are three items that it can be.
In Progress
Not Initiated
COMPLETED
BLANKS
On the Appraisal_Status tab Col F is labeled "Appraisal Assessment and Rating Status".
I need to count In Progress, Not Initiated, Completed & BLANKS and display the count on the Main tab.
Please see the attached.
Thanks.
TEMP-Appraisal-Status.xlsx
TEMP-Appraisal-Status-Jigs.xlsx