Spreadsheet: 840587d1692825511-formula-for-counting-the-number-of-time-certain-text-appears-csat-scores
Sheet: YTD Details

SURVEY ASSIGNEE | SUPERVISOR | MANAGER | CLAIM ID | ECC Responded Date Complete | ECC Responded Answer | ECC Updated Date Complete | ECC Updated Answer | CSAT Date Complete | CSAT Answer | ADJUSTER | FIELD CAT
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Neither satisfied or dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Neither satisfied or dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Neither satisfied or dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | Krystal M Adams
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Somewhat satisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely dissatisfied |  | [NAME]
 |  |  |  |  |  |  |  |  | Extremely satisfied |  | [NAME]