Help with counting of this data
Please, assist me with a formular to use in sorting and counting the number of FCR and ESCALATED issue under the STATUS against QUERY. Please find table below.
QUERY TYPE STATUS
Language Barrier FCR
BB Issue- bundle activation FCR
VAS Issues FCR
Browsing \Data Issue- Customer’s education FCR
Share and Sell Issue FCR
Bonus\Promo Enquiry FCR
Tariff Plan Migration -Enquiry FCR
Credit balance\Missing Minutes Escalated
BB Issue- bundle activation FCR
Recharge Issue- System downtime Escalated
Call Issue-network related FCR
Credit balance\Missing Minutes FCR
Browsing \Data Issue- Device related FCR
Available products and services-Enquiry FCR
VAS Issues FCR
Credit balance\Missing Minutes FCR
No response FCR
VAS Issues FCR
Dropped calls FCR
Dropped calls FCR
BB Issue- bundle activation FCR
Browsing \Data Issue- bundle activation FCR
Tariff Plan Migration -Enquiry FCR
Attachment | Size |
---|---|
Help.xlsx | 12.82 KB |
=SUM(($A$2:$A$77=$F2)*($B$2:$
=SUM(($A$2:$A$77=$F2)*($B$2:$B$77=$H$1)) Ctrl+shift+enter