Spreadsheet: 841821d1693978597-formula-need-count-cells-with-numeric-value-where-column-header-matches-specific-text-random-aligw
Sheet: Random generator

First Name | Last Name | CountA | CountB | CountC | Gender | Age | [NAME] | Phone | Education | Occupation | Experience (Years) | Salary | [NAME] | Number of Children | A | B | C | First Name | Last Name | Gender | Age | [NAME] | Phone | Experience (Years) | Salary | A | B | C | First Name | Last Name | Age | [NAME] | Experience (Years) | Salary | Number of Children | A | B | C
Fenton | [NAME] |  |  |  | Male | 29 | [EMAIL] | 982-4997-88 | Master | [NAME] | 12 | 3452 | Married | 0 | 1734285364 |  | 3169787115 | Caroline | Wells | Female | 28 | [EMAIL] | 404-8550-86 | 5 | 7555 | 1659104583 |  |  | Wilson | [NAME] | 19 | [EMAIL] | 6 | 9337 | 2 | 9575052792
[NAME] | [NAME] |  |  |  | Female | 19 | [EMAIL] | 695-9264-98 | Primary | Engineer | 9 | 3630 | Single | 3 | 9608002566 | 1507019036 |  | [NAME] | Henderson | Female | 18 | [EMAIL] | 883-0335-85 | 5 | 6969 | 6290993535 | 1444421950 | 5815947536 | Lily | Hill | 28 | [EMAIL] | 9 | 9753 | 2 | 5416616710 |  | 7038566134
Byron | Mason |  |  |  | Male | 28 | [EMAIL] | 866-4764-90 | Bachelor | Electrician | 0 | 5931 | Married | 2 | 5356027175 | 3417339373 | [PHONE] | Alford | [NAME] | Male | 18 | [EMAIL] | 458-9955-87 | 4 | 9337 |  | 8803952340 | 3038476019 | Kristian | Richards | 22 | [EMAIL] | 5 | 6279 | 3 | 3264077312 | [PHONE] | 7194026781
[NAME] | [NAME] |  |  |  | Male | 25 | [EMAIL] | 290-0347-41 | Master | Photographer | 1 | 2964 | Single | 2 | 2942211720 |  |  | Cadie | Johnston | Female | 19 | [EMAIL] | 994-1549-86 | 0 | 7589 | 3500289450 | 1156034558 | 6036691722 | Deanna | Ellis | 26 | [EMAIL] | 6 | 4285 | 0 |  | 8608424862
[NAME] | Ellis |  |  |  | Female | 28 | [EMAIL] | 948-0216-22 | Bachelor | Meteorologist | 1 | 4141 | Single | 2 |  | 4381432277 | 3199884704 | April | Cooper | Female | 29 | [EMAIL] | 874-4818-47 | 13 | 3433 | [PHONE] | 9009394277 | 8911158118 | Tara | [NAME] | 20 | [EMAIL] | 7 | 7161 | 0 | [PHONE] | 2319106503
Lucas | [NAME] |  |  |  | Male | 28 | [EMAIL] | 489-1284-30 | Primary | Graphic Designer | 9 | 4062 | Married | 4 | 3164819186 | 4977745665 | 2515597603 | [NAME] | Gray | Male | 23 | [EMAIL] | 382-7731-66 | 11 | 5978 | 4587968658 | 8916578357 |  | Martin | Reed | 23 | [EMAIL] | 7 | 8377 | 0 | 2989745171 | 7111904524 | 7098826455
[NAME] | Adams |  |  |  | Male | 22 | [EMAIL] | 454-2712-04 | Lower secondary | Actor | 5 | 1586 | Married | 2 | 9122851205 | 9026353554 | 7328648392 | [NAME] | Cole | Male | 18 | [EMAIL] | 257-6556-01 | 2 | 2609 |  |  |  | [NAME] | [NAME] | 28 | [EMAIL] | 11 | 3509 | 4 | 9847843019 | 9837253430 | 4459195143
Naomi | Walker |  |  |  | Female | 25 | [EMAIL] | 053-1597-84 | Primary | Interior Designer | 7 | 7584 | Married | 4 | 7553472162 | 8888894636 | 5402109173 | Alen | [NAME] | Male | 26 | [EMAIL] | 897-7653-34 | 8 | 8653 | 4794278047 |  |  | [NAME] | [NAME] | 22 | [EMAIL] | 0 | 8712 | 4 |  |  | 1723125040
[NAME] | [NAME] |  |  |  | Male | 23 | [EMAIL] | 944-6663-29 | Upper secondary | Electrician | 5 | 8191 | Married | 2 | 3897908246 |  | 4169902608 | Tyler | Adams | Male | 24 | [EMAIL] | 127-0022-30 | 7 | 4772 | 4490995318 | 6161087728 | 4741715449 | Byron | [NAME] | 27 | [EMAIL] | 0 | 6971 | 1 | 1536171274 | 9270477586 | 7199752722
Amber | Grant |  |  |  | Female | 29 | [EMAIL] | 969-6684-25 | Doctoral | Veterinarian | 4 | 4307 | Single | 1 | 6851339177 | [PHONE] |  | [NAME] | Bailey | Female | 30 | [EMAIL] | 092-1478-01 | 7 | 3482 | 7306025579 |  |  | Carina | Grant | 26 | [EMAIL] | 11 | 1034 | 5 | 9575052792 | 9323585766 | 5311242637
Derek | Riley |  |  |  | Male | 26 | [EMAIL] | 889-8122-38 | Primary | Driver | 9 | 1527 | Single | 2 |  | 8968477187 |  | [NAME] | [NAME] | Male | 29 | [EMAIL] | 774-3246-37 | 4 | 9907 | 9694232010 |  |  | Nicole | Chapman | 27 | [EMAIL] | 13 | 3334 | 2 |  | 8225151630 | 7134775528
Chloe | Phillips |  |  |  | Female | 21 | [EMAIL] | 727-6141-35 | Master | [NAME] | 3 | 1293 | Married | 3 | 4419172606 | 3318294599 |  | Victoria | Turner | Female | 25 | [EMAIL] | 143-3834-08 | 12 | 5935 | 7311915778 | 4335728950 | 3195562472 | Roland | Henderson | 18 | [EMAIL] | 0 | 9967 | 1 | 1525038644 |  | 5822623127
[NAME] | [NAME] |  |  |  | Female | 19 | [EMAIL] | 914-9006-04 | Lower secondary | [NAME] | 6 | 4253 | Married | 4 | 8576626252 | 5313478376 |  | Ellia | [NAME] | Female | 23 | [EMAIL] | 700-4447-74 | 5 | 4639 | 3455941986 | [PHONE] | [PHONE] | Jared | [NAME] | 30 | [EMAIL] | 5 | 2094 | 3 | 4855774717 | 2510943421
[NAME] | [NAME] |  |  |  | Female | 26 | [EMAIL] | 600-3537-60 | Master | Fashion Designer | 10 | 7816 | Single | 0 | 8411872104 | 1672233004 |  | Tess | [NAME] | Female | 30 | [EMAIL] | 651-4754-00 | 11 | 2766 |  |  | 1768586795 | [NAME] | [NAME] | 28 | [EMAIL] | 14 | 4746 | 5 | 3039289196 | 1089931379 | 2816536218
[NAME] | Chapman |  |  |  | Female | 29 | [EMAIL] | 025-9596-49 | Master | Pharmacist | 10 | 1151 | Single | 2 |  | 4837504567 |  | Julia | Myers | Female | 19 | [EMAIL] | 300-6929-28 | 8 |  | 8661975834 | 4753330328 | 4491161826 | [NAME] | [NAME] | 21 | [EMAIL] | 9 | 1083 | 3 | 5657635396 | 2583720690 | 1366067287
[NAME] | Johnston |  |  |  | Male | 20 | [EMAIL] | 997-8730-66 | Primary | Astronomer | 9 | 6813 | Married | 4 | 5334098521 | 2912210629 |  | Tyler | Gray | Male | 21 | [EMAIL] | 856-6150-42 | 8 | 8645 |  | 1505066033 |  | Stella | Barnes | 19 | [EMAIL] | 6 | 8280 | 1
Roland | Henderson |  |  |  | Male | 21 | [EMAIL] | 250-4046-19 | Master | [NAME] | 5 | 5801 | Married | 1 | 1689138878 |  |  | Camila | [NAME] | Female | 30 | [EMAIL] | 688-8502-00 | 13 | 2448 | 3956547441 |  |  | Aiden | [NAME] | 18 | [EMAIL] | 8 | 3680 | 0
Stella | Edwards |  |  |  | Female | 22 | [EMAIL] | 882-0184-67 | Bachelor | Geologist | 5 | 9621 | Married | 4 | 5661567466 |  | 5113799011 | Alissa | West | Female | 26 | [EMAIL] | 859-2305-59 | 13 | 9519 | 7202829582 | 2117334146 | 1511631656 | Kelsey | Scott | 20 | [EMAIL] | 5 | 3450 | 2
[NAME] | [NAME] |  |  |  | Male | 24 | [EMAIL] | 563-4829-40 | Bachelor | Programmer | 10 | 8738 | Married | 0 | 7801428247 |  | 1255530380 | Maximilian | [NAME] | Male | 18 | [EMAIL] | 730-2007-56 | 4 | 7569 | 6094703654 |  |  | Stuart | [NAME] | 29 | [EMAIL] | 1 | 3053 | 4
Amelia | Hawkins |  |  |  | Female | 24 | [EMAIL] | 051-2542-20 | Bachelor | Programmer | 0 | 9826 | Married | 0 | 5770222026 | 3451257252 | 6792579279 | Connie | Mason | Female | 29 | [EMAIL] | 747-8333-11 | 8 | 9154 | 2883734418 | 7648319556 | 8049381487 | [NAME] | Rogers | 26 | [EMAIL] | 2 | 6843 | 5