Spreadsheet: 73219d1273848607-excel-2007-averaging-across-rows-based-on-some-criteria-example
Sheet: Sheet2

Sex | Continent | Country | Location | Temp_Station | MeanTemp1 | MeanTemp2 | MeanTemp3 | MeanTemp4 | MeanTemp5 | MeanTemp6 | [NAME] | MeanTemp8 | MeanTemp9 | MeanTemp10 | MeanTemp11 | MeanTemp12 | MeanTempSD1 | MeanTempSD2 | MeanTempSD3 | MeanTempSD4 | MeanTempSD5 | MeanTempSD6 | MeanTempSD7 | MeanTempSD8 | MeanTempSD9 | MeanTempSD10 | MeanTempSD11 | MeanTempSD12
1 | European | Norway | Bergen | 1317000
2 | European | Norway | Bergen | 1317000
1 | European | Norway | Oslo | 1489001
2 | European | Norway | Oslo | 1489001
1 | European | Sweden | national | 2226000
2 | European | Sweden | national | 2226000
1 | European | Sweden | Stockholm | 2590000
2 | European | Sweden | Stockholm | 2590000
1 | European | Finland | rural | 2897000
2 | European | Finland | rural | 2897000 | -11.8948717948718 | -11.68717948717949 | -6.594871794871795 | 0.01052631578947369 | 7.364102564102564 | 13.2078947368421 | 15.67692307692308 | 13.35897435897436 | 7.858974358974359 | 2.230769230769231 | -3.74102564102564 | -9.142105263157895 | 4.81368382393517 | 4.141712046661728 | 3.43035587519711 | 1.775020285180503 | 1.999142866262962 | 1.93884635229548 | 1.581049208339278 | 1.397689437064999 | 1.591212372725499 | 2.159575231888491 | 2.915450488682123 | 4.393646000511353
1 | European | Finland | south | 2897000 | -11.8948717948718 | -11.68717948717949 | -6.594871794871795 | 0.01052631578947369 | 7.364102564102564 | 13.2078947368421 | 15.67692307692308 | 13.35897435897436 | 7.858974358974359 | 2.230769230769231 | -3.74102564102564 | -9.142105263157895 | 4.81368382393517 | 4.141712046661728 | 3.43035587519711 | 1.775020285180503 | 1.999142866262962 | 1.93884635229548 | 1.581049208339278 | 1.397689437064999 | 1.591212372725499 | 2.159575231888491 | 2.915450488682123 | 4.393646000511353
2 | European | Finland | south | 2897000 | -11.8948717948718 | -11.68717948717949 | -6.594871794871795 | 0.01052631578947369 | 7.364102564102564 | 13.2078947368421 | 15.67692307692308 | 13.35897435897436 | 7.858974358974359 | 2.230769230769231 | -3.74102564102564 | -9.142105263157895 | 4.81368382393517 | 4.141712046661728 | 3.43035587519711 | 1.775020285180503 | 1.999142866262962 | 1.93884635229548 | 1.581049208339278 | 1.397689437064999 | 1.591212372725499 | 2.159575231888491 | 2.915450488682123 | 4.393646000511353
1 | European | Finland | Helsinki | 2974000
2 | European | Finland | Helsinki | 2974000
1 | European | United Kingdom | London | 3534000
1 | European | United Kingdom | London | 3534000
2 | European | United Kingdom | London | 3534000
2 | European | United Kingdom | London | 3534000
1 | European | Belgium | Brussels | 6260000
1 | European | Belgium | Brussels | 6260000
2 | European | Belgium | Brussels | 6260000
2 | European | Belgium | Brussels | 6260000
1 | European | Netherlands | national | 6260000
2 | European | Netherlands | national | 6260000
1 | European | Switzerland | Basel | 6660000
2 | European | Switzerland | Basel | 6660000 | -0.7748201438848921 | 0.751079136690647 | 4.343478260869568 | 8.568115942028982 | 12.9705035971223 | 16.30575539568345 | 18.05035971223021 | 17.25755395683452 | 14.14460431654676 | 8.951079136690646 | 3.933812949640288 | 0.3654676258992806 | 2.400576426103176 | 2.621244502153283 | 1.983617447583091 | 1.709910379144932 | 1.796915764940377 | 1.587485925267858 | 1.586371947755691 | 1.331936501145034 | 1.489439767349086 | 1.49333625645781 | 1.498431738486458 | 2.378244152890093
1 | European | Switzerland | Zurich | 6660000 | -0.7748201438848921 | 0.751079136690647 | 4.343478260869568 | 8.568115942028982 | 12.9705035971223 | 16.30575539568345 | 18.05035971223021 | 17.25755395683452 | 14.14460431654676 | 8.951079136690646 | 3.933812949640288 | 0.3654676258992806 | 2.400576426103176 | 2.621244502153283 | 1.983617447583091 | 1.709910379144932 | 1.796915764940377 | 1.587485925267858 | 1.586371947755691 | 1.331936501145034 | 1.489439767349086 | 1.49333625645781 | 1.498431738486458 | 2.378244152890093
2 | European | Switzerland | Zurich | 6660000 | -0.7748201438848921 | 0.751079136690647 | 4.343478260869568 | 8.568115942028982 | 12.9705035971223 | 16.30575539568345 | 18.05035971223021 | 17.25755395683452 | 14.14460431654676 | 8.951079136690646 | 3.933812949640288 | 0.3654676258992806 | 2.400576426103176 | 2.621244502153283 | 1.983617447583091 | 1.709910379144932 | 1.796915764940377 | 1.587485925267858 | 1.586371947755691 | 1.331936501145034 | 1.489439767349086 | 1.49333625645781 | 1.498431738486458 | 2.378244152890093
1 | African | Mozambique | [NAME] | 6837000
2 | African | Mozambique | [NAME] | 6837000
1 | African | Mozambique | Maputo | 6837000
2 | African | Mozambique | Maputo | 6837000
1 | African | Mozambique | Maputo (slum) | 6837000
2 | African | Mozambique | Maputo (slum) | 6837000
1 | African | Mozambique | Maputo (urban) | 6837000
2 | African | Mozambique | Maputo (urban) | 6837000
1 | European | France | Paris | 7145000
1 | European | France | Paris | 7145000
2 | European | France | Paris | 7145000
2 | European | France | Paris | 7145000
1 | European | Spain | Madrid | 8220001
2 | European | Spain | Madrid | 8220001
1 | European | Spain | villages (lower class) | 8220001
2 | European | Spain | villages (lower class) | 8220001
2 | European | Czechoslovakia | gypsies | 9407000
1 | European | German Federal Republic | Hamburg | 10147000
2 | European | German Federal Republic | Hamburg | 10147000
1 | European | German Federal Republic | [NAME] and Hamburg | 10147000
2 | European | German Federal Republic | [NAME] and Hamburg | 10147000
1 | European | Denmark | Copenhagen | 10170000
2 | European | Denmark | Copenhagen | 10170000
1 | European | German Democratic Republic | national | 10469000
2 | European | German Democratic Republic | national | 10469000
1 | European | German Federal Republic | urban | 10628000
1 | European | German Federal Republic | urban | 10628000
2 | European | German Federal Republic | urban | 10628000
2 | European | German Federal Republic | urban | 10628000
1 | European | Austria | Vienna | 11035000
2 | European | Austria | Vienna | 11035000
1 | European | Austria | [NAME] | 11231000
2 | European | Austria | [NAME] | 11231000
1 | European | Czechoslovakia | Prague | 11464000
2 | European | Czechoslovakia | Prague | 11464000
1 | European | Czechoslovakia | national | 11782000
2 | European | Czechoslovakia | national | 11782000
1 | European | Poland | Warsaw | 12375000
1 | European | Poland | Warsaw | 12375000
2 | European | Poland | Warsaw | 12375000
2 | European | Poland | Warsaw | 12375000
1 | European | Poland | Wroclaw | 12424000
2 | European | Poland | Wroclaw | 12424000
1 | European | Czechoslovakia | gypsies | 12510000
1 | European | Hungary | Budapest | 12840000
2 | European | Hungary | Budapest | 12840000
1 | European | Yugoslavia | Lika(rural) | 14236000
2 | European | Yugoslavia | Lika(rural) | 14236000
1 | European | Italy | Naples | 14445000
2 | European | Italy | Naples | 14445000
1 | European | Yugoslavia | gypsies | 14654000
2 | European | Yugoslavia | gypsies | 14654000
1 | European | Hungary | Szeged | 15247000
2 | European | Hungary | Szeged | 15247000
1 | European | Bulgaria | Sofia | 15613000
2 | European | Bulgaria | Sofia | 15613000
1 | European | Italy | Genoa | 16080000
2 | European | Italy | Genoa | 16080000
1 | European | Italy | Carrara | 16158000
2 | European | Italy | Carrara | 16158000
1 | European | Italy | Rome | 16158000
2 | European | Italy | Rome | 16158000
1 | European | Italy | Sardinia | 16560000
2 | European | Italy | Sardinia | 16560000
1 | European | Greece | rural | 16641000
2 | European | Greece | rural | 16641000
1 | European | Greece | urban | 16641000
2 | European | Greece | urban | 16641000
1 | European | Turkey | Istanbul (poor) | 17062000
2 | European | Turkey | Istanbul (poor) | 17062000
1 | European | Turkey | Istanbul (well-off) | 17062000
2 | European | Turkey | Istanbul (well-off) | 17062000
1 | Asian | Turkey | Aydin | 17220001
2 | Asian | Turkey | Aydin | 17220001
1 | European | Estonia SSR | national | 26231000
2 | European | Estonia SSR | national | 26231000
1 | European | USSR | Moscow | 27612000
2 | European | USSR | Moscow | 27612000
1 | European | Rumania | national (rural) | 33889000
2 | European | Rumania | national (rural) | 33889000
1 | European | Rumania | national (urban) | 33889000
2 | European | Rumania | national(urban) | 33889000
2 | Asian | Iran | Rasht | 37985000
1 | Asian | Iraq | Baghdad (poor) | 40045000
2 | Asian | Iraq | Baghdad (poor) | 40045000
1 | Asian | Iraq | Baghdad (well-off) | 40045000
2 | Asian | Iraq | Baghdad (well-off) | 40045000
1 | Asian | Lebanon | North, South, Mt. Lebanon, Beirut, Beka'a Valley | 40080000
2 | Asian | Lebanon | North, South, Mt. Lebanon, Beirut, Beka'a Valley | 40080000
2 | Asian | Israel | Arabs | 40184000
1 | Asian | Israel | [NAME] (Jews) | 40184000
2 | Asian | Israel | [NAME] (Jews) | 40184000
1 | Asian | Jordan | Northeast & Central | 40184000
2 | Asian | Jordan | Northeast & Central | 40184000
1 | Asian | Iran | [NAME] (well-off) | 40416000
2 | Asian | Iran | [NAME] (well-off) | 40416000
1 | Asian | Bangladesh | urban | 41929000
2 | Asian | Bangladesh | urban | 41929000
1 | Asian | India | Delhi (well-off) | 42182000
2 | Asian | India | Delhi (well-off) | 42182000
1 | Asian | India | Agra & Buchpuri | 42261000
1 | Asian | India | Agra & Buchpuri | 42261000
2 | Asian | India | Agra & Buchpuri | 42261000
2 | Asian | India | Agra & Buchpuri | 42261000
1 | Asian | India | Bhopal & Gwalior (Maharashtrians) | 42671000
2 | Asian | India | Bhopal & Gwalior (Maharashtrians) | 42671000
1 | Asian | India | India B, Class I | 42867000
2 | Asian | India | India B, Class I | 42867000
1 | Asian | India | national | 42867000
2 | Asian | India | national | 42867000
1 | Asian | India | National (well-off) | 42867000
1 | Asian | India | National (well-off) | 42867000
2 | Asian | India | National (well-off) | 42867000
2 | Asian | India | welloff | 42867000
1 | Asian | North Korea & South Korea | national (1965) | 47108000
2 | Asian | North Korea & South Korea | national (1965) | 47108000
1 | Asian | North Korea & South Korea | national (1975) | 47108000
2 | Asian | North Korea & South Korea | national (1975) | 47108000
1 | Asian | North Korea & South Korea | national (1984) | 47108000
2 | Asian | North Korea & South Korea | national (1984) | 47108000
1 | Asian | North Korea & South Korea | national (1997) | 47108000
2 | Asian | North Korea & South Korea | national (1997) | 47108000
1 | Asian | North Korea & South Korea | national (2005) | 47108000
2 | Asian | North Korea & South Korea | national (2005) | 47108000
1 | Asian | South Korea | national | 47135000
2 | Asian | South Korea | national | 47135000
1 | Asian | Japan | Zinego (rural) | 47582000
2 | Asian | Japan | Zinego (rural) | 47582000
1 | Asian | Japan | Tokyo | 47662000
1 | Asian | Japan | Tokyo | 47662000
2 | Asian | Japan | Tokyo | 47662000
2 | Asian | Japan | Tokyo | 47662000
1 | Asian | Japan | national | 47690001
2 | Asian | Japan | national | 47690001
1 | Asian | Taiwan | Taipei | 47912000
2 | Asian | Taiwan | Taipei | 47912000
1 | Asian | Japan | [NAME] | 47936000
2 | Asian | Japan | [NAME] | 47936000
1 | Asian | Burma | [NAME] (rural) | 48378000
2 | Asian | Burma | [NAME] (rural) | 48378000
1 | Asian | Thailand | [NAME] | 48455000
2 | Asian | Thailand | [NAME] | 48455000
1 | Asian | Thailand | Bangkok | 48455000
2 | Asian | Thailand | Bangkok | 48455000
1 | Asian | Malaysia | Muar (rural) | 48665000
2 | Asian | Malaysia | Muar (rural) | 48665000
1 | Asian | Singapore | Chinese | 48665000
2 | Asian | Singapore | Chinese | 48665000
1 | Asian | Singapore | Malay | 48665000
2 | Asian | Singapore | Malay | 48665000
1 | Asian | China | Xinjiang | 51463000
2 | Asian | China | Xinjiang | 51463000
1 | Asian | China | Han (rural)  1985 | 52652000
2 | Asian | China | Han (rural)  1985 | 52652000
1 | Asian | China | Han (rural)  1995 | 52652000
2 | Asian | China | Han (rural)  1995 | 52652000
1 | Asian | China | Han (urban) 1985 | 52652000
2 | Asian | China | Han (urban) 1985 | 52652000
1 | Asian | China | Han (urban) 1995 | 52652000
2 | Asian | China | Han (urban) 1995 | 52652000
1 | Asian | China | Jinan  1962 | 54823000
2 | Asian | China | Jinan  1962 | 54823000
1 | Asian | China | Jinan  1985 | 54823000
2 | Asian | China | Jinan  1985 | 54823000
1 | Asian | China | Jinan  2000 | 54823000
2 | Asian | China | Jinan  2000 | 54823000
1 | Asian | China | Qingdao 1962 | 54945000
2 | Asian | China | Qingdao 1962 | 54945000
1 | Asian | China | [NAME] 1985 | 54945000
2 | Asian | China | [NAME] 1985 | 54945000
1 | Asian | China | Qingdao 2000 | 54945000
2 | Asian | China | Qingdao 2000 | 54945000
1 | Asian | China | Dongxiang 1985 | 56080002
2 | Asian | China | Dongxiang 1985 | 56080002
1 | Asian | China | Dongxiang 1995 | 56080002
2 | Asian | China | Dongxiang 1995 | 56080002
1 | Asian | China | Shanghai | 58265000
2 | Asian | China | Shanghai | 58265000
1 | Asian | Taiwan | Tainan | 59134000
2 | Asian | Taiwan | Tainan | 59134000
1 | Asian | China | Hong Kong (well-off) | 59493000
1 | Asian | China | Hong Kong (well-off) | 59493000
2 | Asian | China | Hong Kong (well-off) | 59493000
2 | Asian | China | Hong Kong (well-off) | 59493000
1 | Asian | Philippines | national | 59981000
2 | Asian | Philippines | national | 59981000
1 | African | Tunisia | Tunis (poor) | 60715000
2 | African | Tunisia | Tunis (poor) | 60715000
1 | African | Tunisia | Tunis (well-off) | 60715000
2 | African | Tunisia | Tunis (well-off) | 60715000
2 | African | [NAME] | Segou Region (rural) | 61272000
2 | African | [NAME] | Segou Region (urban) | 61272000
1 | African | [NAME] | Sikasso Region | 61297000
2 | African | [NAME] | Sikasso Region | 61297000
1 | African | Senegal | [NAME] | 61641000
2 | African | Senegal | [NAME] | 61641000
2 | African | Senegal | [NAME] | 61641000
1 | African | Gambia | Keneba village (Madinkas) | 61695000
2 | African | Gambia | Keneba village (Madinkas) | 61695000
1 | African | Liberia | Monrovia | 61891000
2 | African | Liberia | Monrovia | 61891000
1 | African | Egypt | Siwa Oasis | 62306000
2 | African | Egypt | Siwa Oasis | 62306000
1 | African | Egypt | national | 62378000
2 | African | Egypt | national | 62378000
1 | African | Sudan | [NAME] | 62721000
2 | African | Sudan | [NAME] | 62721000
1 | African | Ethiopia | Addis Ababa | 62752000
2 | African | Ethiopia | Addis Ababa | 62752000
1 | African | Ethiopia | Gondar | 62752000
2 | African | Ethiopia | Gondar | 62752000
1 | African | D.R. of Congo (Zaire) | Bunia | 63740000
1 | African | D.R. of Congo (Zaire) | Bunia | 63740000
2 | African | D.R. of Congo (Zaire) | Bunia | 63740000
2 | African | D.R. of Congo (Zaire) | Bunia | 63740000
1 | African | Kenya | Suba district | 63740000
2 | African | Kenya | Suba district | 63740000
1 | African | Rwanda | Hutu | 63740000
2 | African | Rwanda | Hutu (national) | 63740000
1 | African | Rwanda | Tutsi | 63740000
2 | African | Rwanda | Tutsi (national) | 63740000
1 | African | Tanzania | Nyakyusa | 63740000
2 | African | Tanzania | Nyakyusa | 63740000
1 | African | Tanzania | [NAME] | 63740000
2 | African | Tanzania | [NAME] | 63740000
1 | African | Uganda | Kampala A | 63740000
2 | African | Uganda | Kampala A | 63740000
2 | African | Uganda | Kampala B | 63740000
1 | African | Tanzania | Kisi | 63962000
2 | African | Tanzania | Kisi | 63962000
1 | African | Tanzania | national (Bantu) | 63962000
2 | African | Tanzania | national (Bantu) | 63962000
1 | African | D.R. of Congo (Zaire) | Kinshasa | 64551001
1 | African | D.R. of Congo (Zaire) | Lemfu | 64551001
1 | African | Nigeria | [NAME] (slum) | 65335000
2 | African | Nigeria | [NAME] (slum) | 65335000
1 | African | Nigeria | [NAME] (well-off) | 65335000
2 | African | Nigeria | [NAME] (well-off) | 65335000
1 | African | Nigeria | Imesi village | 65335000
2 | African | Nigeria | Imesi village | 65335000
1 | African | Nigeria | Lagos | 65344000
2 | African | Nigeria | Lagos | 65344000
1 | African | Nigeria | Lagos (slum) | 65344000
2 | African | Nigeria | Lagos (slum) | 65344000
1 | African | Nigeria | Lagos (well-off) | 65344000
2 | African | Nigeria | Lagos (well-off) | 65344000
1 | African | Nigeria | Lagos (workers) | 65344000
2 | African | Nigeria | Lagos (workers) | 65344000
1 | African | Ghana | Accra, Anloga, Kumasi, Tamale | 65376000
1 | African | Ghana | Accra, Anloga, Kumasi, Tamale | 65376000
2 | African | Ghana | Accra, Anloga, Kumasi, Tamale | 65376000
2 | African | Ghana | Accra, Anloga, Kumasi, Tamale | 65376000
1 | African | [NAME] | Blantyre | 67693000
2 | African | [NAME] | Blantyre | 67693000
1 | African | [NAME] | Chikwawa & Nsanje districts | 67693000
2 | African | [NAME] | Chikwawa & Nsanje districts | 67693000
1 | African | Zambia | [NAME] | 67743000
2 | African | Zambia | [NAME] | 67743000
1 | African | Zambia | [NAME] (North) | 67743000
2 | African | Zambia | [NAME] (North) | 67743000
1 | African | Zambia | [NAME] (South) | 67743000
2 | African | Zambia | [NAME] (South) | 67743000
1 | African | Zimbabwe | Mutoko | 67775000
2 | African | Zimbabwe | Mutoko | 67775000
1 | African | South Africa | Pedi(rural) | 68262000
2 | African | South Africa | Pedi(rural) | 68262000
1 | African | South Africa | Pretoria | 68262000
1 | African | South Africa | Pretoria | 68262000
2 | African | South Africa | Pretoria | 68262000
2 | African | South Africa | Pretoria | 68262000
1 | African | Botswana | Kgalagadi region | 68406000
2 | African | Botswana | Kgalagadi region | 68406000
2 | N American | Canada | Wainwright Eskimo | 70026000
1 | N American | USA | Wainwright Eskimo | 70026000
1 | N American | USA | Fort Apache Reservation, AZ | 72374001
2 | N American | USA | Fort Apache Reservation, AZ | 72374001
1 | N American | USA | Blackfeet | 72779002
2 | N American | USA | Blackfeet | 72779002
1 | N American | Mexico | Tlaltizapan | 76662001
2 | N American | Mexico | Tlaltizapan | 76662001
1 | N American | Mexico | Oaxaca (Zapotec) | 76775002
2 | N American | Mexico | Oaxaca (Zapotec) | 76775002
1 | N American | Guatemala | Maya | 78583000
2 | N American | Guatemala | Maya | 78583000
1 | S American | Surinam | Trio & Wajana | 82191000
2 | S American | Surinam | Trio & Wajana | 82191000
1 | S American | Peru | Nunoa (Quechua) | 84782000
2 | S American | Peru | Nunoa (Quechua) | 84782000
1 | S American | Bolivia | Southwest districts | 85245000
2 | S American | Bolivia | Southwest districts | 85245000
1 | Australian | Fiji |  | 91753000
2 | Australian | Fiji |  | 91753000
1 | Australian | New Zealand | Maori (national) | 92845002
2 | Australian | New Zealand | Maori | 93436001
1 | Australian | New Guinea | Bundi | 94027000
2 | Australian | New Guinea | Bundi | 94027000
1 | Australian | New Guinea | Kaiapit | 94027000
2 | Australian | New Guinea | Kaiapit | 94027000
1 | Australian | New Guinea | Karkar Island | 94027000
2 | Australian | New Guinea | Karkar Island | 94027000
1 | Australian | New Guinea | Lumi | 94027000
2 | Australian | New Guinea | Lumi | 94027000
1 | Australian | New Guinea | Manus | 94027000
2 | Australian | New Guinea | Manus | 94027000
1 | Australian | New Guinea | Mt Hagen | 94027000
2 | Australian | New Guinea | Mt Hagen | 94027000
1 | Australian | Australia | Goulburn, Milingimbi, Elcho Islands (Aborigine) | 94132000
2 | Australian | Australia | Goulburn, Milingimbi, Elcho Islands (Aborigine) | 94132000
1 | Australian | Australia | Aborigine B | 94326000
2 | Australian | Australia | Aborigine B | 94326000
1 | Australian | Australia | Yuendumo (Aborigine) | 94326000
2 | Australian | Australia | Yuendumo (Aborigine) | 94326000