Spreadsheet: 734290d1622095023-how-to-automatically-sum-cell-with-some-condition-excel-query2
Sheet: District I

Checker
SOURCE |  |  |  |  |  | PSA
A |  | B |  |  |  | CC
Number | zone | HH no. | NOTE | Individual Income | Household Income | Income Cluster Cluster
 |  |  | IN OTHER PLACE |  |  | 1 Television  2 Radio  3 Internet(Computer/ Phone)  4 Newspaper  5 Municipal/ Barangay Dessimination  6 Hearsay 7. None |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | strong, exalted | Male | Filipino
1 | 1 | 1 | NO | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ??? | Female | Filipino
2 | 1 |  | NO | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | father of nations | Male | Filipino
3 | 1 |  | NO | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Abel | a breath | Male | Filipino
4 | 1 |  | NO | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | father of nations | Male | Filipino
5 | 1 |  | NO | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adan | a form of [NAME], of the earth | Male | Filipino
6 | 1 |  | NO | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adolpho | noble [NAME] | Male | Filipino
7 | 1 | 3 | NO | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adonis | extremely good looking, lord | Male | Filipino
8 | 1 |  | NO | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | beloved | Male | Filipino
9 | 1 | 3-A | NO | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | a good friend | Female | Filipino
10 | 1 |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Akira | clear, bright | Male | Filipino
11 | 1 |  | NO | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alain | little rock | Male | Filipino
12 | 1 |  | NO | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME], [NAME] | little rock | Male | Filipino
13 | 1 | 3-b | NO | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | noble and bright | Male | Filipino
14 | 1 |  | NO | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aldo | old, noble | Male | Filipino
15 | 1 |  | YES | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alec, Alex | defender of men | Male | Filipino
16 | 1 |  | YES | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alejandro
17 | 1 |  | YES | r
18 | 1 |  | NO | y
19 | 1 | 5VACANT | YES |  |  | 2,3,4
20 | 1 |  | YES
21 | 1 |  | YES
22 | 1 |  | YES
23 | 1 |  | YES
24 | 1 | 8 | NO |  |  | 2,3,4
25 | 1 |  | NO
26 | 1 |  | NO
27 | 1 |  | NO
28 | 1 | 10 | NO
29 | 1 |  | YES
30 | 1 |  | YES