I'm having some challenges calculating NPS in a spreadsheet.
I have the total NPS score, using formula =100*(COUNTIF(K:K;">8")-COUNTIF(K:K;"<5"))/COUNT(K:K) - This calculate the total NPS of all rows i column K in my spreadsheet.
My challenge is, that I need to calculate the same number, but only for the rows with the value "Backoffice" in my column F. How do I do this?
I have the total NPS score, using formula =100*(COUNTIF(K:K;">8")-COUNTIF(K:K;"<5"))/COUNT(K:K) - This calculate the total NPS of all rows i column K in my spreadsheet.
My challenge is, that I need to calculate the same number, but only for the rows with the value "Backoffice" in my column F. How do I do this?