Spreadsheet: 683522d1592808247-conditional-formatting-shows-incorrect-icons-under-percent-conditonal_formatting_4_icon_percent
Sheet: Sheet1

 | No. | CUSTOMERS | PIC 1 | PIC2 | PIC 3 | PIC 4 | PIC 5 | PIC 6 | PIC 7 | PIC 8 | PIC 9 | PIC 10 | PIC 11 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 1 | Customer 1 | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 2 | Customer 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 3 | Customer 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 4 | Customer 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 5 | Customer 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 6 | Customer 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 7 | Customer 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 8 | Customer 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. I
 | 9 | Customer 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 10 | Customer 10 | Mr. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 11 | Customer 11
 | 12 | Customer 12
 | 13 | Customer 13
 | 14 | Customer 14
 | 15 | Customer 15
 | 16 | Customer 16 |  |  |  |  |  |  |  |  | Mr. [NAME]
 | 17 | Customer 17
 | 18 | Customer 18 |  | Mr. [NAME] | Mr. [NAME]
 | 19 | Customer 19
 | 20 | Customer 20
 | 21 | Customer 21 | Mr. [NAME] |  |  |  |  |  | Mr. [NAME]
 | 22 | Customer 22 | Mr. [NAME]
 | 23 | Customer 23
 | No. | CUSTOMERS/ PIC | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. I | Mr. [NAME] | Mr. [NAME] |  |  | COUNTIF
 | 1 | Customer 1 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 2 | Customer 2 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 3 | Customer 3 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 4 | Customer 4 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 5 | Customer 5 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 6 | Customer 6 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 7 | Customer 7 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 8 | Customer 8 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 9 | Customer 9 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. I |  |  | Mr. I
 | 10 | Customer 10 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 11 | Customer 11 |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME] |  |  | Mr. [NAME]
 | 12 | Customer 12
 | 13 | Customer 13
 | 14 | Customer 14
 | 15 | Customer 15
 | 16 | Customer 16
 | 17 | Customer 17
 | 18 | Customer 18
 | 19 | Customer 19
 | 20 | Customer 20
 | 21 | Customer 21
 | 22 | Customer 22
 | 23 | Customer 23
 |  | SUM
 |  | COUNT
 |  | [NAME]:
 |  | https://www.excelforum.com/excel-formulas-and-functions/1298481-countifs-not-working-for-2-values-but-pivot-is-working-fine.html#post5239807