Spreadsheet: 865490d1712576468-sumproduct-count-values-in-a-range-if-adjacent-cell-meets-a-particular-criteria-dummy-workbook
Sheet: Sheet1

 | Dates | Number of times langauge is at the date | Language Code |  |  | Language Code | Language | Total number of times language is used
 | 1640 | 1 | eng |  |  | eng | English
 | 1845 | 1 | ger |  |  | ger | German
 | 1851 | 1 | eng |  |  | fre | French
 | 1876 | 2 | fre |  |  | lat | Latin
 | 1877 | 0 | eng |  |  | und | Undetermined
 | 1878 | 0 | eng |  |  | swe | Swedish
 | 1882 | 2 | eng |  |  | rus | Russian
 |  | 20 | lat |  |  | spa | Spanish
 | 1883 | 88 | ger |  |  | [NAME] | Danish
 | 1884 | 1 | eng |  |  | grc | Greek, Ancient (to 1453)
 |  | 4 | fre |  |  | cze | Czech
 | 1885 | 1 | eng |  |  | dut | Dutch
 | 1886 | 2 | eng |  |  | ita | Italian
 |  | 4 | fre |  |  | pol | Polish
 | 1888 | 1 | fre |  |  | gre | Greek, Modern (1453-)
 | 1889 | 1 | eng |  |  | bul | Bulgarian
 |  | 7 | lat |  |  | [NAME] | Hungarian
 | 1890 | 1 | eng |  |  | nor | Norwegian
 | 1891 | 4 | eng |  |  | por | Portuguese
 |  | 1 | ger |  |  | cat | Catalan
 | 1892 | 28 | fre |  |  | chu | Church Slavic
 |  | 4 | ger |  |  | heb | Hebrew
 |  | 10 | ita |  |  | slv | Slovenian
 | 1893 | 1 | eng |  |  | [NAME] | Arabic
 |  | 4 | ger |  |  | glg | Galician
 |  | 1 | grc |  |  | hrv | Croatian
 | 1894 | 3 | eng |  |  | ice | Icelandic
 |  | 1 | ger |  |  | mul | Multiple languages
 | 1895 | 5 | eng |  |  | nds | Low German
 |  | 2 | ger |  |  | rum | Romanian
 |  | 3 | lat |  |  | aar | Afar
 | 1896 | 4 | eng |  |  | abk | Abkhaz
 |  | 4 | fre |  |  | ace | Achinese
 | 1897 | 3 | eng |  |  | ach | Acoli
 |  | 4 | ger |  |  | ada | Adangme
 | 1898 | 3 | eng |  |  | ady | Adygei
 |  | 1 | fre |  |  | afa | Afroasiatic (Other)
 |  | 4 | ger |  |  | afh | Afrihili (Artificial language)
 | 1899 | 6 | eng |  |  | [NAME] | Afrikaans
 |  | 5 | ger |  |  | ain | Ainu
 |  | 9 | grc |  |  | -ajm | Aljamía
 | 1900 | 4 | [NAME] |  |  | aka | Akan
 |  | 8 | eng |  |  | akk | Akkadian
 |  | 3 | fre |  |  | alb | Albanian
 |  | 6 | ger |  |  | ale | Aleut
 |  | 2 | lat |  |  | alg | [NAME] (Other)
 |  | 2 | und |  |  | alt | Altai
 | 1901 | 1 | chu |  |  | amh | Amharic
 |  | 1 | dut |  |  | [NAME] | English, [NAME] (ca. 450-1100)
 |  | 5 | eng |  |  | anp | Angika
 |  | 3 | fre |  |  | apa | Apache languages
 |  | 5 | ger |  |  | arc | Aramaic
 |  | 2 | grc |  |  | arg | Aragonese
 |  | 1 | [NAME] |  |  | arm | Armenian
 |  | 24 | lat |  |  | arn | Mapuche
 |  | 1 | rus |  |  | arp | Arapaho
 | 1902 | 1 | bul |  |  | art | Artificial (Other)
 |  | 7 | eng |  |  | arw | Arawak
 |  | 3 | fre |  |  | asm | Assamese
 |  | 3 | ger |  |  | ast | Bable
 |  | 13 | grc |  |  | ath | Athapascan (Other)
 |  | 1 | [NAME] |  |  | aus | Australian languages
 |  | 17 | lat |  |  | ava | Avaric
 |  | 1 | pol |  |  | ave | Avestan
 |  | 2 | rus |  |  | awa | [NAME]
 |  | 1 | swe |  |  | aym | [NAME]
 | 1903 | 5 | cze |  |  | aze | Azerbaijani
 |  | 1 | dut |  |  | bad | Banda languages
 |  | 15 | eng |  |  | bai | [NAME] languages
 |  | 5 | fre |  |  | bak | [NAME]
 |  | 15 | ger |  |  | bal | Baluchi
 |  | 5 | grc |  |  | bam | Bambara
 |  | 1 | [NAME] |  |  | ban | Balinese
 |  | 2 | lat |  |  | baq | Basque
 | 1904 | 10 | eng |  |  | bas | Basa
 |  | 30 | fre |  |  | bat | Baltic (Other)
 |  | 13 | ger |  |  | bej | Beja
 |  | 1 | gre |  |  | bel | Belarusian
 |  | 3 | lat |  |  | bem | Bemba
 |  | 4 | rus |  |  | [NAME] | Bengali
 |  | 1 | spa |  |  | ber | Berber (Other)
 |  | 3 | und |  |  | bho | Bhojpuri
 | 1905 | 1 | cze |  |  | bih | Bihari (Other)
 |  | 1 | [NAME] |  |  | bik | [NAME]
 |  | 15 | eng |  |  | [NAME] | Edo
 |  | 5 | fre |  |  | bis | Bislama
 |  | 30 | ger |  |  | [NAME] | Siksika
 |  | 3 | grc |  |  | bnt | Bantu (Other)
 |  | 3 | lat |  |  | bos | Bosnian
 |  | 2 | mul |  |  | bra | Braj
 |  | 4 | rus |  |  | bre | Breton
 | 1906 | 18 | eng |  |  | btk | Batak
 |  | 5 | fre |  |  | bua | Buriat
 |  | 8 | ger |  |  | bug | Bugis
 |  | 4 | grc |  |  | bur | Burmese
 |  | 3 | lat |  |  | byn | Bilin
 |  | 4 | rus |  |  | cad | Caddo
 |  | 4 | und |  |  | cai | Central American Indian (Other)
 | 1907 | 1 | [NAME] |  |  | -cam | Khmer
 |  | 16 | eng |  |  | car | Carib
 |  | 24 | fre |  |  | cau | Caucasian (Other)
 |  | 10 | ger |  |  | ceb | Cebuano
 |  | 18 | por |  |  | cel | Celtic (Other)
 |  | 1 | rus |  |  | [NAME] | Chamorro
 |  | 2 | und |  |  | chb | [NAME]
 | 1908 | 2 | cze |  |  | che | Chechen
 |  | 20 | eng |  |  | chg | Chagatai
 |  | 9 | fre |  |  | chi | Chinese
 |  | 9 | ger |  |  | chk | Chuukese
 |  | 3 | grc |  |  | chm | [NAME]
 |  | 1 | gre |  |  | chn | Chinook jargon
 |  | 1 | ita |  |  | [NAME] | Choctaw
 |  | 15 | lat |  |  | chp | Chipewyan
 |  | 2 | pol |  |  | chr | Cherokee
 |  | 2 | rum |  |  | chv | Chuvash
 |  | 3 | rus |  |  | chy | [NAME]
 |  | 1 | slv |  |  | cmc | Chamic languages
 |  | 1 | spa |  |  | cnr | Montenegrin
 |  | 1 | swe |  |  | cop | Coptic
 |  | 3 | und |  |  | cor | Cornish
 | 1909 | 1 | cze |  |  | cos | Corsican
 |  | 1 | [NAME] |  |  | cpe | Creoles and [NAME], English-based (Other)
 |  | 1 | dut |  |  | cpf | Creoles and Pidgins, French-based (Other)
 |  | 24 | eng |  |  | cpp | Creoles and [NAME], Portuguese-based (Other)
 |  | 5 | fre |  |  | cre | Cree
 |  | 10 | ger |  |  | crh | Crimean Tatar
 |  | 1 | grc |  |  | crp | Creoles and Pidgins (Other)
 |  | 1 | gre |  |  | csb | Kashubian
 |  | 3 | ita |  |  | cus | Cushitic (Other)
 |  | 2 | lat |  |  | dak | Dakota
 |  | 2 | rus |  |  | dar | Dargwa
 |  | 1 | spa |  |  | day | [NAME]
 |  | 1 | swe |  |  | del | Delaware
 |  | 7 | und |  |  | den | Slavey
 | 1910 | 1 | bul |  |  | dgr | Dogrib
 |  | 1 | cat |  |  | din | Dinka
 |  | 1 | chu |  |  | div | [NAME]
 |  | 1 | cze |  |  | doi | Dogri
 |  | 1 | [NAME] |  |  | dra | [NAME] (Other)
 |  | 15 | eng |  |  | dsb | Lower Sorbian
 |  | 12 | fre |  |  | dua | Duala
 |  | 10 | ger |  |  | dum | Dutch, Middle (ca. 1050-1350)
 |  | 1 | grc |  |  | dyu | [NAME]
 |  | 2 | ita |  |  | dzo | Dzongkha
 |  | 4 | lat |  |  | efi | Efik
 |  | 3 | pol |  |  | egy | Egyptian
 |  | 1 | spa |  |  | eka | Ekajuk
 |  | 5 | und |  |  | elx | Elamite
 | 1911 | 1 | dut |  |  | enm | English, Middle (1100-1500)
 |  | 11 | eng |  |  | epo | Esperanto
 |  | 10 | fre |  |  | -esk | Eskimo languages
 |  | 13 | ger |  |  | -esp | Esperanto
 |  | 1 | grc |  |  | est | Estonian
 |  | 2 | ita |  |  | -eth | Ethiopic
 |  | 12 | lat |  |  | ewe | Ewe
 |  | 2 | pol |  |  | ewo | Ewondo
 |  | 1 | rus |  |  | fan | Fang
 |  | 5 | und |  |  | fao | Faroese
 | 1912 | 26 | eng |  |  | -far | Faroese
 |  | 6 | fre |  |  | fat | Fanti
 |  | 18 | ger |  |  | fij | Fijian
 |  | 1 | ita |  |  | fil | Filipino
 |  | 1 | lat |  |  | fin | Finnish
 |  | 1 | nor |  |  | fiu | Finno-Ugrian (Other)
 |  | 1 | pol |  |  | fon | [NAME]
 |  | 4 | rus |  |  | -fri | Frisian
 |  | 3 | swe |  |  | frm | French, Middle (ca. 1300-1600)
 |  | 2 | und |  |  | fro | French, [NAME] (ca. 842-1300)
 | 1913 | 21 | eng |  |  | frr | North Frisian
 |  | 9 | fre |  |  | frs | East Frisian
 |  | 12 | ger |  |  | [NAME] | Frisian
 |  | 2 | ita |  |  | ful | Fula
 |  | 6 | lat |  |  | fur | Friulian
 |  | 1 | slv |  |  | [NAME] | [NAME]
 |  | 1 | spa |  |  | -gae | Scottish Gaelix
 |  | 1 | swe |  |  | -gag | Galician
 |  | 1 | und |  |  | -gal | Oromo
 | 1914 | 1 | cze |  |  | gay | Gayo
 |  | 1 | [NAME] |  |  | gba | [NAME]
 |  | 20 | eng |  |  | gem | Germanic (Other)
 |  | 10 | fre |  |  | geo | Georgian
 |  | 14 | ger |  |  | [NAME] | Ethiopic
 |  | 1 | gre |  |  | [NAME] | Gilbertese
 |  | 20 |  |  |  | gla | Scottish Gaelic
 |  | 1 |  |  |  | gle | Irish
 |  | 5 | rus |  |  | glv | Manx
 |  | 4 | spa |  |  | [NAME] | German, Middle High (ca. 1050-1500)
 |  | 2 | swe |  |  | [NAME] | German, Old High (ca. 750-1050)
 |  | 3 | und |  |  | gon | Gondi
 | 1915 | 1 | cze |  |  | gor | Gorontalo
 |  | 1 | [NAME] |  |  | got | Gothic
 |  | 1 | dut |  |  | grb | Grebo
 |  | 10 | eng |  |  | grn | Guarani
 |  | 2 | fre |  |  | gsw | Swiss German
 |  | 4 | ger |  |  | -gua | Guarani
 |  | 3 | grc |  |  | guj | Gujarati
 |  | 3 | lat |  |  | gwi | Gwich'in
 |  | 3 | pol |  |  | hai | Haida
 |  | 2 | spa |  |  | hat | Haitian French Creole
 |  | 2 | swe |  |  | hau | Hausa
 |  | 3 | und |  |  | haw | Hawaiian
 | 1916 | 1 | [NAME] |  |  | her | Herero
 |  | 17 | eng |  |  | [NAME] | Hiligaynon
 |  | 15 | fre |  |  | him | Western Pahari languages
 |  | 4 | ger |  |  | hin | Hindi
 |  | 1 | heb |  |  | hit | Hittite
 |  | 2 | ita |  |  | hmn | Hmong
 |  | 4 | lat |  |  | hmo | [NAME]
 |  | 2 | nor |  |  | hsb | Upper Sorbian
 |  | 1 | rus |  |  | hup | Hupa
 |  | 2 | swe |  |  | iba | Iban
 |  | 2 | und |  |  | ibo | Igbo
 | 1917 | 1 | cze |  |  | ido | [NAME]
 |  | 1 | [NAME] |  |  | iii | [NAME]
 |  | 2 | dut |  |  | ijo | Ijo
 |  | 11 |  |  |  | iku | Inuktitut
 |  | 1 | fre |  |  | ile | Interlingue
 |  | 10 | ger |  |  | ilo | Iloko
 |  | 2 | swe |  |  | ina | Interlingua (International Auxiliary Language Association)
 |  | 2 | und |  |  | inc | Indic (Other)
 | 1918 | 4 | eng |  |  | ind | Indonesian
 |  | 3 | ger |  |  | ine | Indo-European (Other)
 |  | 1 | glg |  |  | inh | Ingush
 |  | 1 | ita |  |  | -int | Interlingua (International Auxiliary Language Association)
 |  | 5 | spa |  |  | ipk | Inupiaq
 |  | 1 | swe |  |  | ira | Iranian (Other)
 | 1919 | 1 | bul |  |  | -iri | Irish
 |  | 5 | eng |  |  | iro | Iroquoian (Other)
 |  | 3 | fre |  |  | jav | Javanese
 |  | 11 | ger |  |  | jbo | [NAME] (Artificial language)
 |  | 4 | ice |  |  | jpn | Japanese
 |  | 2 | lat |  |  | jpr | Judeo-Persian
 |  | 1 | por |  |  | jrb | Judeo-Arabic
 |  | 3 | spa |  |  | kaa | Kara-Kalpak
 |  | 1 | swe |  |  | kab | [NAME]
 | 1920 | 1 | cat |  |  | kac | Kachin
 |  | 1 | cze |  |  | [NAME] | Kalâtdlisut
 |  | 5 | dut |  |  | kam | Kamba
 |  | 25 | eng |  |  | kan | [NAME]
 |  | 4 | fre |  |  | kar | Karen languages
 |  | 12 | ger |  |  | kas | Kashmiri
 |  | 1 | spa |  |  | kau | Kanuri
 |  | 1 | swe |  |  | kaw | Kawi
 |  | 4 | und |  |  | kaz | Kazakh
 | 1921 | 1 | cze |  |  | [NAME] | Kabardian
 |  | 21 | eng |  |  | kha | Khasi
 |  | 5 | fre |  |  | khi | [NAME] (Other)
 |  | 11 | ger |  |  | khm | Khmer
 |  | 3 | heb |  |  | [NAME] | Khotanese
 |  | 1 | hrv |  |  | kik | [NAME]
 |  | 1 | lat |  |  | kin | Kinyarwanda
 |  | 2 | spa |  |  | kir | Kyrgyz
 |  | 1 | swe |  |  | [NAME] | Kimbundu
 |  | 3 | und |  |  | kok | Konkani
 | 1922 | 21 | eng |  |  | [NAME] | Komi
 |  | 12 | fre |  |  | kon | Kongo
 |  | 24 | ger |  |  | kor | Korean
 |  | 1 | gre |  |  | kos | Kosraean
 |  | 1 | lat |  |  | [NAME] | [NAME]
 |  | 3 | pol |  |  | krc | Karachay-Balkar
 |  | 2 | spa |  |  | krl | Karelian
 |  | 4 | swe |  |  | kro | Kru (Other)
 |  | 1 | und |  |  | kru | Kurukh
 | 1923 | 3 | [NAME] |  |  | kua | [NAME]
 |  | 16 | eng |  |  | kum | Kumyk
 |  | 8 | fre |  |  | kur | Kurdish
 |  | 19 | ger |  |  | -kus | Kusaie
 |  | 2 | ita |  |  | kut | Kootenai
 |  | 5 | lat |  |  | [NAME] | Ladino
 |  | 1 | nds |  |  | [NAME] | Lahndā
 |  | 1 | rus |  |  | lam | Lamba (Zambia and Congo)
 |  | 1 | spa |  |  | -lan | Occitan (post 1500)
 |  | 2 | und |  |  | lao | Lao
 | 1924 | 1 | [NAME] |  |  | -lap | Sami
 |  | 2 | dut |  |  | [NAME] | Latvian
 |  | 23 | eng |  |  | [NAME] | Lezgian
 |  | 10 | fre |  |  | lim | Limburgish
 |  | 9 | ger |  |  | [NAME] | [NAME]
 |  | 9 | lat |  |  | lit | Lithuanian
 |  | 1 |  |  |  | lol | Mongo-Nkundu
 |  | 1 | pol |  |  | loz | Lozi
 |  | 1 | por |  |  | ltz | Luxembourgish
 |  | 1 | spa |  |  | lua | Luba-Lulua
 |  | 6 | und |  |  | lub | Luba-Katanga
 | 1925 | 1 | [NAME] |  |  | lug | [NAME]
 |  | 1 | bul |  |  | lui | Luiseño
 |  | 2 | [NAME] |  |  | lun | [NAME]
 |  | 1 | dut |  |  | [NAME] | Luo (Kenya and Tanzania)
 |  | 22 | eng |  |  | lus | Lushai
 |  | 15 | fre |  |  | mac | Macedonian
 |  | 18 | ger |  |  | mad | Madurese
 |  | 3 | lat |  |  | mag | Magahi
 |  | 2 | rus |  |  | mah | Marshallese
 |  | 1 | swe |  |  | mai | Maithili
 |  | 4 | und |  |  | mak | [NAME]
 | 1926 | 1 | dut |  |  | mal | Malayalam
 |  | 18 | eng |  |  | man | Mandingo
 |  | 11 | fre |  |  | mao | Maori
 |  | 29 | ger |  |  | map | Austronesian (Other)
 |  | 17 | lat |  |  | [NAME] | Marathi