Трекер удовлетворенности клиентов (CSAT) и Net Promoter Score (NPS)
=AVERAGEIFS($C$2:$C$100,$D$2:$D$100,E2) & " CSAT Score" & " | " & (COUNTIFS($C$2:$C$100,>=9"ADVERTISEMENT - IN-ARTICLE
Руководство
$D$2:$D$100
=AVERAGEIFS($C$2:$C$100,$D$2:$D$100,E2) & " CSAT Score" & " | " & (COUNTIFS($C$2:$C$100,>=9"