Spreadsheet: 860927d1708950822-how-to-calculate-empty-cells-when-filter-is-applied-countif
Sheet: Sheet1

 |  |  |  |  | none empty cell count
 |  |  |  |  | empty cell count |  | ?
 |  |  |  |  | Subtotal
Payer Region | Payer Territory | STP | P Code | Payer | Payer Sale Point | Category | DAP
Lahore Region | [NAME] | 1002213 | 3002249 | Khalid & Brothers | Eminabad Mor_SP | Dealer | 625
Lahore Region | [NAME] | 1002216 | 3002256 | Rana Arsalan & Co. | Dhillanwali_SP | Dealer | 540
Lahore Region | [NAME] | 1003106 | 3003927 | [NAME] | Dhillanwali_SP | Dealer | 460
Lahore Region | [NAME] | 1002221 | 3002285 | [NAME] | Dhillanwali_SP | Dealer
Lahore Region | [NAME] | 1002214 | 3002252 | [NAME] | Dhillanwali_SP | Dealer
Lahore Region | [NAME] | 1002273 | 3009393 | Ali & Co | Kamoke_SP | Dealer
Lahore Region | [NAME] | 1002066 | 3002062 | [NAME] Traders | [NAME] | Dealer | 80
Lahore Region | Hafizabad Territory | 1002353 | 3010615 | Standard Fertilizer | Hafizabad_SP | Dealer | 700
Lahore Region | Hafizabad Territory |  | 3010702 | [NAME] |  | Dealer | 190
Lahore Region | Hafizabad Territory | 1007421 | 3010026 | Minhas Agro & Services | Hafizabad_SP | Dealer | 40
Lahore Region | Hafizabad Territory | 1000074 | 3000074 | [NAME] | Sukheke_SP | Dealer | 90
Lahore Region | Hafizabad Territory | 1002209 | 3002242 | Salman & Co | Nokhar_SP | Dealer | 160
Lahore Region | Hafizabad Territory | 1002237 | 3002314 | Khalid Awan Brothers | Hafizabad_SP | Dealer | 105
Lahore Region | Hafizabad Territory | 1003102 | 3004198 | Suleman Sikandar & Co. | [NAME] | Dealer | 50
Lahore Region | Hafizabad Territory | 1002235 | 3002311 | Noor Mohammad Traders | Sukheke_SP | Dealer | 44.25
Lahore Region | Hafizabad Territory | 1003044 | 3003847 | [NAME] Kharal & Co. | Hafizabad_SP | Dealer | 40
Lahore Region | Hafizabad Territory | 1000073 | 3000073 | Ikram & Co | [NAME] | Dealer
Lahore Region | Hafizabad Territory | 1000067 | 3000067 | Nasir Chattah & Co | Hafizabad_SP | Dealer
Lahore Region | Hafizabad Territory | 1000068 | 3000068 | [NAME] | Hafizabad_SP | Dealer
Lahore Region | Hafizabad Territory | 1000060 | 3000060 | Tahir & Brothers | Sukheke_SP | Dealer
Lahore Region | [NAME] | 1002347 | 3005546 | Nadeem & Brothers | Kasur_SP | Dealer | 110
Lahore Region | [NAME] | 1002284 | 3003808 | [NAME] | Hadyara_SP | Dealer | 198
Lahore Region | [NAME] | 1002199 | 3002212 | [NAME] and Brothers | Kasur_SP | Dealer | 130
Lahore Region | [NAME] | 1002145 | 3003935 | Mayo Khad Dealer | [NAME] | Dealer | 118
Lahore Region | [NAME] | 1003317 | 3004343 | Bilal & Co | [NAME] | Dealer | 80
Lahore Region | [NAME] | 1002142 | 3004336 | Eman Traders | Burki_SP | Dealer | 50
Lahore Region | [NAME] | 1004490 | 3006683 | Zain & Company | [NAME] | Dealer
Lahore Region | [NAME] | 1002204 | 3002228 | Ch [NAME] Traders | Kasur_SP | Dealer
Lahore Region | [NAME] | 1003312 | 3004339 | Ghulam Mustafa & Company | Shahdara_SP | Dealer | 70
Lahore Region | [NAME] | 1006988 | 3009293 | [NAME] And Sons | Pattoki_SP | Dealer | 20
Lahore Region | [NAME] | 1002279 | 3002399 | Muhammad Sharif & Brothers | [NAME] | Dealer | 40
Lahore Region | [NAME] | 1004388 | 3006439 | [NAME] Traders [NAME] | Khudian Khas_SP | Dealer | 10
Lahore Region | [NAME] | 1003280 | 3004243 | Ch.Barkat & Sons | [NAME] | Dealer
Lahore Region | [NAME] | 1000145 | 3000145 | Paradise [NAME] | Kasur_SP | Dealer
Lahore Region | [NAME] | 1002273 | 3006299 | ALI & CO. | Burki_SP | Dealer