Spreadsheet: 734146d1622015455-countif-on-visible-cells-only-and-countif-from-a-cell-with-multiple-entry-excel-query-ans
Sheet: District I

Checker
SOURCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PSA | DA
A |  | B |  | C | D | E | F | G | L | M | O | U | V | W | CC | CF1
Number | zone | HH no. | NOTE | Family No. | No. of HH members | No. of Family in the HH | Occupied/ Vacant | LAST NAME | DATE OF BIRTH | Base Date (As of) | Age in Years | SINGLE PARENT | Age at first Marriage 15-ONWARDS females | SEX | Access to Information =SUMPRODUCT(--(ISNUMBER(SEARCH(TEXT,RANGE)))) | Owned Livestock Animals
 |  |  | IN OTHER PLACE |  |  |  | 1 Occupied 2 Vacant |  | JANUARY 1, 2020 |  |  | 1 YES 2 NO |  | 1 MALE  2 FEMALE | 1 Television  2 Radio  3 Internet(Computer/ Phone)  4 Newspaper  5 Municipal/ Barangay Dessimination  6 Hearsay 7. None | 1 Carabao 2 Cow 3 Goat 4 Sheep 5 Horse 6 Pig 7 Others 8 None |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | strong, exalted | Male | Filipino
1 | 1 | 1 | NO |  |  |  | 1 | [NAME] | 1934-11-22 00:00:00 | 2020-09-01 00:00:00 |  |  |  | 1 | 1,2,3,4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ??? | Female | Filipino
2 | 1 | 5 | NO |  |  |  |  | [NAME] | 1988-08-11 00:00:00 |  | 5 |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | father of nations | Male | Filipino
3 | 1 | 5 | NO |  |  |  |  | [NAME] | 1986-03-22 00:00:00 |  | 5 |  | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Abel | a breath | Male | Filipino
4 | 1 | 5 | NO |  |  |  |  | Abel | 2015-03-04 00:00:00 |  | 5 |  | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | father of nations | Male | Filipino
5 | 1 |  | NO |  |  |  |  | [NAME] | 2018-03-24 00:00:00 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adan | a form of [NAME], of the earth | Male | Filipino
6 | 1 |  | NO |  |  |  |  | Adan | 1997-04-27 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adolpho | noble [NAME] | Male | Filipino
7 | 1 | 3 | NO |  |  |  | 1 | Adolpho | 1953-11-12 00:00:00 |  |  |  |  | 1 | 1,3,4,6 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adonis | extremely good looking, lord | Male | Filipino
8 | 1 |  | NO |  |  |  |  | Adonis | 1965-03-08 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | beloved | Male | Filipino
9 | 1 | 3-A | NO |  |  |  |  | [NAME] | 1986-09-30 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | a good friend | Female | Filipino
10 | 1 |  | NO |  |  |  |  | [NAME] | 1981-11-15 00:00:00 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Akira | clear, bright | Male | Filipino
11 | 1 |  | NO |  |  |  |  | Akira | 1976-12-01 00:00:00 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alain | little rock | Male | Filipino
12 | 1 |  | NO |  |  |  |  | Alain | 1999-10-16 00:00:00 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME], [NAME] | little rock | Male | Filipino
13 | 1 | 3-b | NO |  |  |  |  | [NAME], [NAME], [NAME] | 1986-11-29 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | noble and bright | Male | Filipino
14 | 1 |  | NO |  |  |  |  | [NAME], [NAME] | 1986-10-17 00:00:00 |  |  |  | 25 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aldo | old, noble | Male | Filipino
15 | 1 |  | YES |  |  |  |  | Aldo | 2013-03-01 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alec, Alex | defender of men | Male | Filipino
16 | 1 |  | YES |  |  |  |  | Alec, Alex | 2016-07-28 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alejandro
17 | 1 |  | YES |  |  |  |  | Alejandro | 1955-11-24 00:00:00 |  |  |  | 22 | 2
18 | 1 |  | NO |  |  |  |  | DFG | 1990-12-23 00:00:00 |  |  |  |  | 1
19 | 1 | 5VACANT | YES |  |  |  | 2 | FDG | 1970-11-01 00:00:00 |  |  |  | 14 | 1 | 2,3,4
20 | 1 |  | YES |  |  |  |  | FDG | 1977-07-27 00:00:00 |  |  |  | 19 | 2
21 | 1 |  | YES |  |  |  |  | FDG | 1994-10-06 00:00:00 |  |  |  |  | 2
22 | 1 |  | YES |  |  |  |  | DFG | 2002-03-02 00:00:00 |  |  |  |  | 2
23 | 1 |  | YES |  |  |  |  | DFG | 2004-06-02 00:00:00 |  |  |  |  | 1
24 | 1 | 8 | NO |  |  |  | 1 | VBC | 1982-11-08 00:00:00 |  |  |  |  | 1 | 2,3,4
25 | 1 |  | NO |  |  |  |  | UYRTYU | 1986-11-29 00:00:00 |  |  |  | 18 | 2
26 | 1 |  | NO |  |  |  |  | RTYTRY | 2005-12-10 00:00:00 |  |  |  |  | 1
27 | 1 |  | NO |  |  |  |  | RTERT | 2011-05-20 00:00:00 |  |  |  |  | 1
28 | 1 | 10 | NO |  |  |  | 1 | DSTT | 1960-09-28 00:00:00 |  |  |  |  | 1
29 | 1 |  | YES |  |  |  |  | WRWR | 1973-04-25 00:00:00 |  |  |  | 21 | 2
30 | 1 |  | YES |  |  |  |  | [NAME] | 1995-06-19 00:00:00 |  |  |  |  | 1