Spreadsheet: 584933d1533536257-how-to-use-countif-for-special-cell-and-not-for-a-range-system-bdc
Sheet: Sheet1

 |  | Systems | Vishnu |  | Prageeth |  | Sreejith |  | Aswin |  | Sarath |  | [NAME] |  | Sachin |  | Visakh |  |  | Sl. No. | Projects | 2018-08-01 00:00:00 |  | 2018-08-02 00:00:00 |  | 2018-08-03 00:00:00 |  | 2018-08-04 00:00:00 |  | 2018-08-05 00:00:00 |  | 2018-08-06 00:00:00 |  | 2018-08-07 00:00:00 |  | 2018-08-08 00:00:00 |  | 2018-08-09 00:00:00 |  | 2018-08-10 00:00:00 |  | 2018-08-11 00:00:00 |  | 2018-08-12 00:00:00 |  | 2018-08-13 00:00:00 |  | 2018-08-14 00:00:00 |  | 2018-08-15 00:00:00 |  | 2018-08-16 00:00:00 |  | 2018-08-17 00:00:00 |  | 2018-08-18 00:00:00 |  | 2018-08-19 00:00:00 |  | 2018-08-20 00:00:00 |  | 2018-08-21 00:00:00 |  | 2018-08-22 00:00:00 |  | 2018-08-23 00:00:00 |  | 2018-08-24 00:00:00 |  | 2018-08-25 00:00:00 |  | 2018-08-26 00:00:00 |  | 2018-08-27 00:00:00 |  | 2018-08-28 00:00:00 |  | 2018-08-29 00:00:00 |  | 2018-08-30 00:00:00 |  | 2018-08-31 00:00:00
 |  |  | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export |  |  | Systems | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export | Import | Export
 |  | VAGARO | 4 | 1 |  | 2 |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 | VAGARO | vishnu | vishnu | vishnu | [NAME] | Vishnu | sarath | Vishnu | prageeth |  |  | Vishnu |  | SARATH |  | Vishnu
 |  | SCHEDULICITY | 1 |  | 1 | 2 |  |  |  |  | 2 | 2 |  |  |  |  |  |  |  | 3 | SCHEDULICITY | sarath | prageeth | vishnu | sarath | prageeth | sarath | sarath | prageeth
 |  | GENBOOK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GENBOOK
 |  | ROSY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | ROSY
 |  | APPOINTMENTS PLUS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | APPOINTMENTS PLUS
 |  | TIMELY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | TIMELY
 |  | SQUARE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | SQUARE
 |  | FULL SLATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | FULL SLATE
 |  | ACUITY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | ACUITY
 |  | XANDARO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | XANDARO
 |  | SALON IRIS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | SALON IRIS
 |  | SCHEDULISTA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | SCHEDULISTA
 |  | SNAP APPOINTMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | SNAP APPOINTMENTS
 |  | OVATU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | OVATU
 |  | SETMORE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | SETMORE
 |  | WELLNESS LIVING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | WELLNESS LIVING
 |  | BOOK4LIFE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | BOOK4LIFE
 |  | DRCHROMO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | DRCHROMO
 |  | ZENOTI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | ZENOTI
 |  | SALON ULTIMATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | SALON ULTIMATE
 |  | SHEDUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | SHEDUL
 |  | AESTHETICS PRO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | AESTHETICS PRO
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | [NAME]
 |  | CLINKO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | CLINKO
 |  | MASSAGE BOOK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | MASSAGE BOOK
 |  | SOAP VAULT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | SOAP VAULT
 |  | BOOKEO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | BOOKEO
 |  | ESCAPIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | ESCAPIA
 |  | Vcita |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | Vcita
 |  |  | IF((COUNTIF(T10,"X")+COUNTIF(T20,"X")+COUNTIF(T30,"X"))>0,"X","no")