Name SUB 1 SUB 2 SUB 3 SUB 4 SUB 5 SUB 6 total

arun 36 97 29 50 97 56
kirn 95 35 98 35 35 47
latha 35 65 44 35 88 85
asha 35 35 35 30 35 96
varsha 95 70 98 97 74 77
anju 25 35 65 91 75 47
raghu 35 87 44 36 88 85
geetha 15 85 87 74 35 96
pallavi 75 45 35 91 75 47
srinivas 35 87 44 35 88 85
ankith 97 99 95 74 54 96
barath 75 30 30 25 75 47
vishal 20 30 10 25 25 85
arjun 87 95 99 97 56 96
kavya 75 45 65 91 75 47
kavith 35 15 44 35 88 85
manu 87 85 97 99 54 96
min max Result average
classobtain
 Name SUB 1 SUB 2 SUB 3
arun 35 56
kirn 95 45 98
latha 35 87 44
asha 35 35 35
varsha 95 85 98
anju 25 35 35

countif how many 35

USE COUNTIF
35
>70
<=85

COUNT IF MORE OR EQUAL TO 35 BUT LESS THAN 85

2 DIFF CRETRIA 35 AND 85
2 TIMES SELECT THE RANGE
USE COUNTIFS

>=35 & <85 COUNTIFS(B2:H7,">=35",B2:H7,"<85")

SUB 4 SUB 5 SUB 6 Total
93 45 52 281
91 35 47 411
35 88 85 374
35 96 236
97 74 449
91 75 47 308

COUNT ALL THE NUMBERS

count COUNT(A1:B7)
counta COUNTA(A1:B7)
countblank COUNTBLANK(B2:H7)
 Returned Order ID Region RETURNED ORDERS
Yes CA-2012-SA20830140-41210 Central US 1
yes IN-2012-PB19210127-41259 Eastern Asia 1
Yes CA-2012-SC20095140-41174 Central US 1
Yes IN-2015-JH158207-42140 Oceania 1
YES IN-2014-LC168857-41747 Oceania 1
no ID-2013-AB1001527-41439 Eastern Asia 0
Yes ES-2015-RA1994545-42218 Western Europe 1
Yes CA-2014-TB21280140-41724 Central US 1
NO ES-2014-JF15295120-41924 Southern Europe 0
Yes IN-2014-NM1844527-41800 Eastern Asia 1
Yes IN-2015-GB145307-42260 Oceania 1
Yes ES-2012-SC208458-41070 Western Europe 1
Yes TU-2013-SF10200134-41417 Western Asia 1
NO ID-2015-RD1993092-42140 Oceania 0
NO CA-2014-TC21295140-41800 Southern US 0
Yes SF-2015-MV8190117-42362 Southern Africa 1
NO IN-2014-EM1382566-41850 Eastern Asia 0
Yes ES-2015-CC1210045-42182 Western Europe 1
Yes ES-2015-MM1792045-42199 Western Europe 1
NO IN-2015-DB1306027-42353 Eastern Asia 0
NO IN-2013-JC157757-41310 Oceania 0
NO CA-2015-RB19705140-42262 Eastern US 0
Yes ES-2015-BB1154548-42336 Western Europe 1
NO AL-2012-SC102302-40970 Southern Europe 0
Yes UP-2014-MC7275137-41997 Eastern Europe 1
NO IN-2013-EJ13720113-41608 Southeastern Asia 0
Yes CA-2012-AJ10780140-41212 Eastern US 1
Yes CA-2014-EM14140140-41822 Western US 1
NO ES-2015-RD19585120-42007 Southern Europe 0
Yes US-2014-SC20230140-41873 Western US 1
NO IN-2013-JR1570058-41441 Southern Asia 0
Yes IN-2013-DL129257-41418 Oceania 1
NO ES-2014-EG1390045-41644 Western Europe 0
Yes ES-2013-DB1297045-41458 Western Europe 1
NO CA-2014-CL12565140-41768 Eastern US 0
Yes ES-2014-EB13930139-41962 Northern Europe 1
NO IN-2015-ML1739559-42369 Southeastern Asia 0
Yes SA-2015-MC7575110-42326 Western Asia 1
Yes CA-2014-SS1041023-41995 Eastern Canada 1
Yes ID-2015-ST205307-42336 Oceania 1
Yes MX-2012-AH1003082-41251 Central America 1
Yes ID-2015-MM1726078-42181 Southeastern Asia 1
Yes IT-2015-DM1301564-42167 Southern Europe 1
NO IN-2015-JW1595527-42190 Eastern Asia 0
NO CA-2013-SG20080140-41578 Western US 0
NO IN-2014-PF1912027-41916 Eastern Asia 0
NO US-2015-AG1052582-42355 Central America 0
Yes IN-2015-PB191057-42281 Oceania 1
Yes MX-2015-BS1136518-42199 South America 1
Yes IT-2012-MP1817545-41040 Western Europe 1
Yes IN-2014-BT1168027-41815 Eastern Asia 1
Yes IN-2013-MH180257-41443 Oceania 1
Yes ID-2015-LW172157-42293 Oceania 1
Yes MX-2014-KA1652539-41922 Central America 1
Yes ID-2015-CS123557-42328 Oceania 1
Yes IN-2015-KM163757-42342 Oceania 1
NO MX-2013-PK1891082-41532 Central America 0
NO ES-2015-BT1139564-42088 Southern Europe 0
NO MX-2013-CC1243082-41634 Central America 0
NO IT-2015-AR1082545-42290 Western Europe 0
NO ID-2014-CS11860102-41858 Southeastern Asia 0
Yes IN-2014-AB1060058-41858 Southern Asia 1
Yes IN-2012-CG1204027-41252 Eastern Asia 1
Yes AG-2013-PO88653-41634 North Africa 1
Yes EG-2015-CM211538-42144 North Africa 1
Yes ES-2015-BN1151545-42304 Western Europe 1
Yes IN-2014-CL1189066-41999 Eastern Asia 1
Yes ID-2015-AA1064559-42332 Southeastern Asia 1
Yes ES-2014-JK1609064-41800 Southern Europe 1
Yes IN-2015-CD1192059-42326 Southeastern Asia 1
Yes IN-2012-ES1408027-40941 Eastern Asia 1
Yes MX-2013-DO1364512-41461 Caribbean 1
Yes CG-2013-SC1030533-41538 Central Africa 1
Yes SI-2015-SM10005115-42252 Southern Europe 1
Yes IN-2012-GT1471058-41158 Southern Asia 1
Yes ID-2013-SC2080059-41380 Southeastern Asia 1
Yes MX-2013-HF1499518-41423 South America 1
Yes ES-2012-AG1049545-41002 Western Europe 1
Yes IN-2015-SD2048527-42259 Eastern Asia 1
Yes CA-2012-PC18745140-41273 Eastern US 1
Yes US-2015-DH13075140-42092 Western US 1
Yes ES-2015-LR1691545-42237 Western Europe 1
Yes SF-2015-CD1920117-42055 Southern Africa 1
Yes ES-2012-TT2146045-41014 Western Europe 1
Yes IN-2015-PS1904558-42272 Southern Asia 1
Yes CA-2015-KL16555140-42313 Southern US 1
Yes US-2013-PO1918082-41504 Central America 1
Yes ID-2015-JG15310130-42133 Southeastern Asia 1
Yes ES-2014-MG17680120-41867 Southern Europe 1
Yes ES-2015-RA1994548-42249 Western Europe 1
Yes IT-2015-KD1634545-42238 Western Europe 1
Yes CA-2012-DP13165140-41244 Eastern US 1
Yes CA-2014-EH13765140-41997 Western US 1
Yes ID-2015-TB214007-42322 Oceania 1
Yes MX-2013-ES1408018-41619 South America 1
Yes IN-2012-TB2152059-41207 Southeastern Asia 1
Yes ES-2012-MR1754564-41157 Southern Europe 1
Yes IN-2015-GW1460558-42173 Southern Asia 1
Yes CA-2013-JK15205140-41544 Southern US 1
Yes IN-2015-GM1445558-42273 Southern Asia 1
Yes CA-2015-MG18145140-42285 Western US 1
Yes CA-2013-EM13960140-41548 Western US 1
Yes ES-2014-RM1937545-41643 Western Europe 1
Yes IN-2012-GG1465027-40992 Eastern Asia 1
Yes IN-2014-TB2140066-41873 Eastern Asia 1
Yes MX-2015-MP1796518-42189 South America 1
Yes US-2012-LT17110140-41060 Southern US 1
Yes ES-2013-BF1117048-41527 Western Europe 1
Yes ID-2013-CC126857-41572 Oceania 1
Yes ES-2013-AJ1094548-41444 Western Europe 1
Yes US-2015-GZ14545140-42212 Western US 1
Yes ES-2015-BM1165045-42176 Western Europe 1
Yes ID-2014-RD197207-41776 Oceania 1
Yes MX-2015-DB1336018-42280 South America 1
Yes US-2012-CV12295140-40995 Central US 1
Yes IT-2013-BF1102045-41418 Western Europe 1
Yes IN-2015-LT1676511-42286 Southern Asia 1
Yes IN-2015-VB217451-42349 Southern Asia 1
Yes IT-2014-JG15115104-41952 Southern Europe 1
Yes MX-2012-JP1552018-41174 South America 1
Yes MX-2012-RD1993051-41223 Central America 1
Yes IN-2015-AT1043559-42243 Southeastern Asia 1
Yes IN-2012-SC2069559-41248 Southeastern Asia 1
Yes ES-2012-ER13855120-41159 Southern Europe 1
Yes ES-2012-TB2162545-41262 Western Europe 1
Yes ES-2013-CM124458-41375 Western Europe 1
Yes US-2012-BF11170140-41266 Western US 1
Yes ID-2014-CJ1187592-41831 Oceania 1
Yes RS-2015-GG4650108-42102 Eastern Europe 1
Yes ES-2015-KA1652545-42353 Western Europe 1
Yes MX-2014-CW1190593-41788 Central America 1
Yes MX-2015-SV2078582-42347 Central America 1
Yes ES-2012-DJ1351048-40923 Western Europe 1
Yes CA-2014-HF14995140-41761 Southern US 1
Yes CA-2014-CL12565140-41788 Western US 1
Yes CA-2012-LR16915140-41128 Western US 1
Yes CA-2015-KH16510140-42347 Western US 1
Yes MX-2015-KC1667518-42070 South America 1
Yes CA-2014-ON18715140-41959 Southern US 1
Yes IN-2013-MA1799559-41314 Southeastern Asia 1
Yes IS-2014-RA928563-41916 Western Asia 1
Yes IN-2012-TB2162588-41177 Southeastern Asia 1
Yes IN-2012-MC1784559-41116 Southeastern Asia 1
Yes ID-2014-KH16690144-41991 Southeastern Asia 1
Yes ES-2015-AT1073545-42367 Western Europe 1
Yes ES-2014-PO1885048-41898 Western Europe 1
Yes CA-2015-EB13750140-42111 Southern US 1
Yes EG-2015-AC66038-42250 North Africa 1
Yes IN-2013-TH2111558-41488 Southern Asia 1
Yes ES-2012-GH14485139-41054 Northern Europe 1
Yes ES-2014-LL1684048-41986 Western Europe 1
Yes CA-2014-NS18640140-41985 Eastern US 1
Yes ID-2012-MD1786059-40965 Southeastern Asia 1
Yes ES-2012-TB2140048-40968 Western Europe 1
Yes RS-2015-TB11520108-42126 Eastern Europe 1
Yes ID-2015-BG1169588-42012 Southeastern Asia 1
Yes CA-2014-ES14020140-41802 Eastern US 1
Yes ES-2015-HG14965120-42080 Southern Europe 1
Yes MX-2012-SW2075593-41250 Central America 1
Yes CA-2012-BP11095140-41261 Western US 1
Yes IN-2014-BG110357-41735 Oceania 1
Yes ES-2015-EB1417064-42012 Southern Europe 1
Yes MX-2015-EH1418531-42166 Caribbean 1
Yes IN-2015-DS1303058-42173 Southern Asia 1
Yes CA-2015-AG10900140-42126 Southern US 1
Yes ES-2013-DE1325545-41278 Western Europe 1
Yes SA-2013-JD6150110-41600 Western Asia 1
Yes ID-2015-HA1490592-42287 Oceania 1
Yes CA-2013-IM15070140-41459 Central US 1
Yes US-2015-TZ2144518-42259 South America 1
Yes ES-2015-DK1309045-42158 Western Europe 1
Yes MX-2013-PT1909082-41579 Central America 1
Yes ES-2015-EB141108-42267 Western Europe 1
Yes SF-2014-JD6060117-41648 Southern Africa 1
Yes ES-2015-AR1051045-42234 Western Europe 1
Yes IN-2013-CL1270027-41555 Eastern Asia 1
Yes ES-2015-AH1012045-42057 Western Europe 1
Yes IT-2013-ZD2192548-41503 Western Europe 1
Yes IN-2014-DJ1342058-41646 Southern Asia 1
Yes ES-2014-LC1705048-41718 Western Europe 1
Yes MX-2014-AJ1096031-41801 Caribbean 1
Yes CA-2014-CP12340140-41808 Eastern US 1
Yes IN-2013-JK1609027-41615 Eastern Asia 1
Yes AJ-2013-SG108909-41580 Western Asia 1
Yes MX-2015-DV1304593-42215 Central America 1
Yes ES-2013-TP2156545-41598 Western Europe 1
Yes US-2015-HG1484551-42171 Central America 1
Yes IN-2014-AM103607-41864 Oceania 1
Yes CA-2015-DO13645140-42263 Western US 1
Yes ES-2014-JP1552045-41871 Western Europe 1
Yes MX-2013-JR1621037-41627 South America 1
Yes MX-2013-RL1961582-41572 Central America 1
Yes ES-2014-EP1391548-42004 Western Europe 1
Yes IN-2013-CD1228058-41311 Southern Asia 1
Yes MX-2013-EC1405018-41599 South America 1
Yes MX-2013-PO1885051-41338 Central America 1
Yes CA-2012-FP14320140-41251 Eastern US 1
Yes MX-2012-YS2188093-41060 Central America 1
Yes IN-2013-CC1261027-41286 Eastern Asia 1
Yes IN-2014-DB1321027-41899 Eastern Asia 1
Yes MX-2014-JR1570036-41775 Caribbean 1
Yes CA-2013-VD21670140-41583 Southern US 1
Yes CA-2014-BM11785140-41835 Central US 1
Yes ES-2014-JP16135139-41899 Northern Europe 1
Yes US-2012-KB1631598-41064 Central America 1
Yes IN-2012-AM10705130-41151 Southeastern Asia 1
Yes MX-2015-SC2038093-42151 Central America 1
Yes GH-2013-MH729049-41615 Western Africa 1
Yes IN-2013-NC1834058-41385 Southern Asia 1
Yes CA-2013-EB14110140-41377 Western US 1
Yes IN-2015-JF1549078-42334 Southeastern Asia 1
Yes ID-2015-HM148607-42243 Oceania 1
Yes CA-2014-NS18505140-41968 Central US 1
Yes ID-2013-AO1081059-41556 Southeastern Asia 1
Yes CA-2015-VW21775140-42326 Eastern US 1
Yes MO-2013-NK849086-41366 North Africa 1
Yes IN-2014-KL1655592-41857 Oceania 1
Yes CA-2014-SN20560140-41817 Central US 1
Yes MX-2014-SJ2012539-41908 Central America 1
Yes MX-2015-DP1316593-42293 Central America 1
Yes ES-2013-MN1793548-41466 Western Europe 1
Yes SA-2014-SJ10125110-41944 Western Asia 1
Yes IT-2015-ME18010124-42235 Northern Europe 1
Yes CA-2015-AD10180140-42340 Eastern US 1
Yes ID-2014-TB2125059-41973 Southeastern Asia 1
Yes IN-2013-PS187607-41402 Oceania 1
Yes CA-2012-MC17425140-41058 Central US 1
Yes US-2014-DA134505-41926 South America 1
Yes ID-2015-EN137807-42312 Oceania 1
Yes MX-2015-CB1241598-42333 Central America 1
Yes HU-2015-JP552057-42249 Eastern Europe 1
Yes CA-2012-KH16630140-41213 Southern US 1
Yes CA-2012-BS11755140-41046 Eastern US 1
Yes US-2015-SJ2021554-42255 Caribbean 1
Yes MX-2012-KT1646518-41017 South America 1
Yes MX-2015-AS1028518-42351 South America 1
Yes MX-2015-SC2068082-42231 Central America 1
Yes ES-2014-MW1822048-41998 Western Europe 1
Yes MX-2013-MF1766551-41402 Central America 1
Yes CA-2014-JM15535140-41998 Eastern US 1
Yes CA-2012-CC247523-41031 Eastern Canada 1
Yes CA-2012-NC18535140-41112 Western US 1
Yes IN-2013-MM172607-41395 Oceania 1
Yes IN-2013-PR1888027-41430 Eastern Asia 1
Yes NI-2014-RA994595-41979 Western Africa 1
Yes US-2012-RB19435140-41237 Western US 1
Yes ES-2014-LP17095139-41772 Northern Europe 1
Yes MX-2014-FA1423055-41976 Central America 1
Yes IN-2014-SH19975130-41975 Southeastern Asia 1
Yes CA-2014-GK14620140-41753 Western US 1
Yes US-2012-DK1289598-41166 Central America 1
Yes ES-2014-AB10165139-41888 Northern Europe 1
Yes US-2014-SP20860140-41968 Western US 1
Yes IT-2012-GD1459091-40988 Western Europe 1
Yes IN-2014-NB1865527-41858 Eastern Asia 1
Yes PL-2012-JD5790103-41249 Eastern Europe 1
Yes KE-2015-JH598569-42317 Eastern Africa 1
Yes MX-2014-DC1328518-41751 South America 1
Yes ES-2014-HG1502548-41783 Western Europe 1
Yes IV-2014-AM70529-41678 Western Africa 1
Yes RO-2014-ND8370107-41839 Eastern Europe 1
Yes EG-2015-AY55538-42121 North Africa 1
Yes MO-2014-KH669086-41830 North Africa 1
Yes IN-2014-SR2074027-41767 Eastern Asia 1
Yes IN-2013-MF176657-41300 Oceania 1
Yes ES-2013-HM1498064-41289 Southern Europe 1
Yes MX-2015-DL1331582-42335 Central America 1
Yes US-2013-MW1822036-41387 Caribbean 1
Yes US-2014-BG11695140-42001 Central US 1
Yes MX-2014-SW2075582-41811 Central America 1
Yes MO-2014-MO795086-41706 North Africa 1
Yes MX-2015-PO1885082-42279 Central America 1
Yes US-2014-DR12880140-41723 Western US 1
Yes CA-2012-AG10525140-41153 Central US 1
Yes IT-2013-KH1669045-41490 Western Europe 1
Yes US-2012-JP155205-41153 South America 1
Yes CG-2015-AM70533-42233 Central Africa 1
Yes CA-2015-AJ10945140-42248 Central US 1
Yes MX-2013-SO2033526-41400 South America 1
Yes IN-2012-TS2150559-40990 Southeastern Asia 1
Yes CA-2015-MV17485140-42333 Western US 1
Yes IN-2015-SC2038027-42306 Eastern Asia 1
Yes IT-2012-JC1610564-41053 Southern Europe 1
Yes CA-2015-LE16810140-42348 Western US 1
Yes US-2013-BB1099036-41379 Caribbean 1
Yes TU-2013-AH195134-41319 Western Asia 1
Yes MX-2014-TS2120518-41791 South America 1
Yes IR-2012-FH436560-41114 Southern Asia 1
Yes MX-2014-SH2039582-41895 Central America 1
Yes US-2014-GT14710140-41980 Western US 1
Yes IR-2014-BN151560-41880 Southern Asia 1
Yes ES-2012-SH2039545-40914 Western Europe 1
Yes SA-2013-SC10260110-41451 Western Asia 1
Yes CA-2014-BD11605140-41742 Southern US 1
Yes IN-2012-VD2167059-41269 Southeastern Asia 1
Yes ES-2015-MY17380120-42316 Southern Europe 1
Yes CA-2015-LC16870140-42091 Southern US 1
Yes IN-2012-TR2132527-41188 Eastern Asia 1
Yes IN-2014-JC1538558-41815 Southern Asia 1
Yes MX-2012-NG1843018-41201 South America 1
Yes EG-2015-DM301538-42367 North Africa 1
Yes BU-2014-CS186019-41993 Eastern Europe 1
Yes ID-2014-CT11995118-41810 Eastern Asia 1
Yes IN-2012-EH139907-41140 Oceania 1
Yes CA-2012-RD19585140-41000 Southern US 1
Yes CA-2015-CW11905140-42138 Eastern US 1
Yes MX-2014-NC1862593-41955 Central America 1
Yes MX-2013-RB1936082-41552 Central America 1
Yes IN-2012-AS1028527-41034 Eastern Asia 1
Yes IN-2014-AO108107-41721 Oceania 1
Yes MX-2015-HG1484536-42070 Caribbean 1
Yes ID-2015-JE1561097-42193 Southern Asia 1
Yes ES-2014-CY1274564-41726 Southern Europe 1
Yes IR-2014-SM1095060-41746 Southern Asia 1
Yes US-2012-PB1915055-41157 Central America 1
Yes ES-2014-JB1600048-41856 Western Europe 1
Yes ES-2015-JC1577548-42328 Western Europe 1
Yes IT-2014-LP1708091-41907 Western Europe 1
Yes MX-2012-ME1732018-41164 South America 1
Yes CA-2014-TS21655140-41999 Southern US 1
Yes ES-2015-SV20935139-42369 Northern Europe 1
Yes MX-2015-CJ12010141-42298 South America 1
Yes CA-2012-SH20395140-41214 Western US 1
Yes IN-2013-GM1445527-41622 Eastern Asia 1
Yes CA-2013-MS17530140-41579 Southern US 1
Yes US-2013-HD1478598-41583 Central America 1
Yes US-2015-CB1202582-42305 Central America 1
Yes CA-2015-BH11710140-42346 Southern US 1
Yes MX-2012-MO1750016-41222 South America 1
Yes ES-2012-MG17890139-41257 Northern Europe 1
Yes CA-2013-PO19195140-41598 Eastern US 1
Yes ES-2015-KW1643545-42032 Western Europe 1
Yes CA-2013-SS20515140-41479 Southern US 1
Yes MX-2012-RL1961539-40965 Central America 1
Yes MX-2014-SZ2003531-41822 Caribbean 1
Yes ID-2013-BT115307-41508 Oceania 1
Yes MX-2012-TG2131018-41132 South America 1
Yes CA-2012-TT21070140-41159 Southern US 1
Yes CA-2015-TS21505140-42316 Western US 1
Yes ES-2013-AW1084064-41519 Southern Europe 1
Yes CA-2015-DV13045140-42350 Southern US 1
Yes ES-2015-BP11185139-42175 Northern Europe 1
no US-2015-EB13930140-42208 Central US 0
Yes ES-2014-RS1942048-41831 Western Europe 1
Yes CG-2012-MM828033-40983 Central Africa 1
Yes MX-2013-JD1589536-41523 Caribbean 1
Yes IN-2014-DB1291027-41870 Eastern Asia 1
Yes ES-2014-DV1346564-41961 Southern Europe 1
Yes MX-2015-JK1564055-42174 Central America 1
Yes CA-2015-LW17215140-42106 Western US 1
Yes MX-2012-PM1894031-41208 Caribbean 1
Yes BU-2012-EH394519-41265 Eastern Europe 1
Yes MX-2012-VM2183551-41185 Central America 1
Yes CA-2012-AZ10750140-40992 Eastern US 1
Yes IT-2015-KB1631564-42301 Southern Europe 1
Yes IT-2015-EK13795139-42277 Northern Europe 1
Yes ID-2015-AS1009058-42316 Southern Asia 1
Yes MX-2015-MC1742593-42304 Central America 1
Yes MX-2014-DW1358531-41779 Caribbean 1
Yes ES-2015-AB1016545-42356 Western Europe 1
Yes MX-2015-DG1330093-42319 Central America 1
Yes MX-2013-SW2027536-41587 Caribbean 1
Yes MX-2015-SP2065082-42257 Central America 1
Yes IN-2014-CC125507-41963 Oceania 1
Yes ES-2015-CW11905139-42288 Northern Europe 1
Yes ZA-2015-SW10350146-42061 Eastern Africa 1
Yes IN-2015-PR1888027-42125 Eastern Asia 1
Yes ES-2014-DB1327045-41689 Western Europe 1
Yes ES-2012-PM1894045-41145 Western Europe 1
no CA-2013-AG10495140-41571 Central US 0
Yes ES-2012-CD1198048-41151 Western Europe 1
Yes ES-2015-SF20200139-42229 Northern Europe 1
Yes MX-2012-BD1150093-41041 Central America 1
Yes ES-2015-BE11410120-42225 Southern Europe 1
Yes BN-2012-RW963015-41216 Western Africa 1
Yes US-2014-HP148155-41906 South America 1
Yes ES-2015-BF11170139-42174 Northern Europe 1
Yes IN-2015-DB129707-42152 Oceania 1
Yes CA-2012-EH13765140-41199 Eastern US 1
Yes IN-2012-BB115457-41194 Oceania 1
Yes IN-2012-SG206057-40978 Oceania 1
Yes IN-2015-RH1951011-42040 Southern Asia 1
Yes ZA-2014-JW6075146-41739 Eastern Africa 1
Yes ES-2012-JA15970139-41080 Northern Europe 1
Yes IN-2012-JR1567027-41031 Eastern Asia 1
Yes ES-2013-JE1547545-41450 Western Europe 1
Yes IT-2014-LS1720064-41954 Southern Europe 1
Yes IN-2014-CA1226527-41794 Eastern Asia 1
Yes UP-2014-AA645137-41807 Eastern Europe 1
Yes NI-2014-MH745595-41696 Western Africa 1
Yes ID-2015-EJ1415592-42299 Oceania 1
Yes ID-2014-KD1649559-41807 Southeastern Asia 1
Yes ES-2014-DK1298548-41711 Western Europe 1
Yes BU-2014-MH745519-41670 Eastern Europe 1
Yes ID-2015-NR18550102-42078 Southeastern Asia 1
Yes IN-2012-JH1591027-41262 Eastern Asia 1
Yes IN-2012-JL151307-40988 Oceania 1
Yes IT-2015-AG1049545-42229 Western Europe 1
Yes CA-2014-JF15565140-41686 Eastern US 1
Yes IN-2014-SH2063527-41858 Eastern Asia 1
Yes IN-2015-LD1700558-42285 Southern Asia 1
Yes LO-2012-JL5850114-41121 Eastern Europe 1
Yes BO-2014-KH636013-41859 Eastern Europe 1
Yes US-2013-EM1382555-41579 Central America 1
Yes IT-2015-MB1808591-42145 Western Europe 1
Yes SF-2014-EL3735117-41875 Southern Africa 1
Yes TU-2014-JF5565134-41818 Western Asia 1
Yes MX-2014-BM1114055-41961 Central America 1
Yes TU-2015-SW10275134-42311 Western Asia 1
Yes ES-2014-SS208758-41683 Western Europe 1
Yes US-2014-BW1120018-41979 South America 1
Yes IN-2013-TD20995130-41609 Southeastern Asia 1
Yes ES-2015-KB1660096-42048 Northern Europe 1
Yes IN-2015-Dl1360058-42364 Southern Asia 1
Yes ES-2014-MB18085139-41956 Northern Europe 1
Yes IT-2015-AR10345139-42116 Northern Europe 1
Yes IN-2013-JG1531027-41602 Eastern Asia 1
Yes ES-2014-MC1810045-41982 Western Europe 1
Yes CA-2015-HG15025140-42363 Eastern US 1
Yes MO-2015-AB25586-42117 North Africa 1
Yes US-2012-CS1246036-41247 Caribbean 1
Yes ES-2014-JD1606045-41699 Western Europe 1
Yes MX-2013-EM1381018-41552 South America 1
Yes MX-2015-MY1829582-42321 Central America 1
Yes CA-2015-KH16330140-42329 Eastern US 1
Yes ES-2014-MG18205139-41867 Northern Europe 1
Yes CA-2015-DO13645140-42343 Eastern US 1
Yes IN-2014-ML177557-41922 Oceania 1
Yes SA-2015-AR570110-42299 Western Asia 1
no US-2015-LH16900140-42348 Central US 0
Yes CA-2015-JE15745140-42111 Western US 1
no CA-2013-MV17485140-41450 Central US 0
Yes IT-2012-KH16690104-41037 Southern Europe 1
Yes IN-2015-SL2015558-42222 Southern Asia 1
Yes MX-2012-KM1672018-41242 South America 1
Yes ID-2014-DB132107-41934 Oceania 1
Yes IN-2012-CM1223527-41248 Eastern Asia 1
Yes IN-2014-BD116207-41650 Oceania 1
Yes CA-2015-OT18730140-42304 Southern US 1
Yes AO-2013-JE57454-41544 Central Africa 1
Yes EG-2014-SC1009538-41847 North Africa 1
Yes ID-2013-GZ144707-41467 Oceania 1
Yes ES-2015-MJ17740139-42073 Northern Europe 1
Yes IR-2014-MM805560-41990 Southern Asia 1
Yes IT-2014-TP2141545-41858 Western Europe 1
Yes ID-2013-TG21640102-41508 Southeastern Asia 1
Yes IN-2014-LS172307-41954 Oceania 1
Yes IN-2012-GM1444058-41200 Southern Asia 1
Yes TU-2012-AJ960134-40990 Western Asia 1
Yes CA-2014-PF19225140-41817 Southern US 1
Yes IN-2014-TB2162558-41724 Southern Asia 1
Yes MX-2012-ND1837082-41223 Central America 1
Yes ID-2015-MG1814592-42132 Oceania 1
Yes CA-2014-CA12265140-41677 Southern US 1
Yes SF-2012-MH7440117-41065 Southern Africa 1
Yes MX-2012-AB1015093-41101 Central America 1
Yes IZ-2015-EM396061-42110 Western Asia 1
Yes IN-2015-AW1084058-42083 Southern Asia 1
Yes ES-2015-PS1897045-42179 Western Europe 1
Yes ES-2013-WB2185064-41587 Southern Europe 1
Yes CA-2015-NC18535140-42096 Western US 1
Yes MX-2014-LS1697518-41666 South America 1
Yes IN-2012-SB2018559-41157 Southeastern Asia 1
Yes ML-2014-BD177079-41893 Western Africa 1
Yes MX-2015-CM1244582-42354 Central America 1
Yes MX-2012-AW1084082-41192 Central America 1
Yes MX-2015-CL1270093-42180 Central America 1
Yes CA-2015-CC12475140-42278 Eastern US 1
Yes MX-2014-AH1069093-41990 Central America 1
Yes AO-2013-SF102004-41628 Central Africa 1
Yes MX-2014-SZ2003518-41703 South America 1
Yes EG-2015-RA994538-42342 North Africa 1
Yes TU-2015-AG495134-42130 Western Asia 1
Yes IN-2012-PR1888058-41013 Southern Asia 1
Yes ES-2015-CS1235548-42010 Western Europe 1
Yes IN-2015-MH1811558-42185 Southern Asia 1
Yes IN-2015-JP1546058-42258 Southern Asia 1
Yes IR-2015-CA196560-42201 Southern Asia 1
Yes MX-2013-AF1087026-41536 South America 1
Yes US-2012-JF15490140-41269 Western US 1
Yes IN-2015-PS18760102-42263 Southeastern Asia 1
Yes ES-2014-KT1646548-41678 Western Europe 1
Yes ES-2014-MC1760548-41900 Western Europe 1
Yes MX-2014-BE1145531-41650 Caribbean 1
Yes CA-2015-BP11095140-42352 Eastern US 1
Yes CG-2014-ML775533-41740 Central Africa 1
Yes ID-2014-CV1280527-41773 Eastern Asia 1
Yes SA-2013-RF9840110-41277 Western Asia 1
Yes SF-2012-AG675117-40976 Southern Africa 1
Yes US-2015-CR12820140-42284 Eastern US 1
Yes ES-2013-MB1808545-41629 Western Europe 1
Yes IN-2015-SC20260130-42032 Southeastern Asia 1
Yes IN-2012-TS211607-41179 Oceania 1
Yes IZ-2015-MO795061-42271 Western Asia 1
Yes MX-2014-LL1684039-41853 Central America 1
Yes ES-2013-EB14110139-41528 Northern Europe 1
Yes CA-2015-BT11530140-42278 Western US 1
Yes ES-2013-LC1714064-41409 Southern Europe 1
Yes US-2013-DG13300140-41458 Eastern US 1
Yes CA-2014-IG15085140-41808 Western US 1
Yes ES-2015-LO17170139-42166 Northern Europe 1
Yes IN-2015-SS2059059-42364 Southeastern Asia 1
Yes AG-2014-CP20853-41889 North Africa 1
Yes US-2012-AB1025582-40928 Central America 1
Yes TU-2014-PK8910134-41798 Western Asia 1
Yes IT-2015-JW1522091-42234 Western Europe 1
Yes CA-2013-RH19510140-41544 Western US 1
Yes ES-2014-DM13015120-41856 Southern Europe 1
Yes NI-2013-JB600095-41621 Western Africa 1
Yes US-2015-TC2114555-42166 Central America 1
Yes IT-2013-DJ1351064-41352 Southern Europe 1
Yes IN-2012-DB131207-41257 Oceania 1
Yes IZ-2015-EH412561-42161 Western Asia 1
Yes US-2013-KB16315140-41318 Eastern US 1
Yes CA-2015-CV12805140-42025 Eastern US 1
Yes MX-2015-AG1052518-42357 South America 1
Yes IN-2012-MP179657-41242 Oceania 1
Yes IN-2015-PG1882097-42251 Southern Asia 1
Yes ES-2012-SW2024548-41073 Western Europe 1
Yes IT-2012-MC1742548-41177 Western Europe 1
Yes TU-2012-CS1845134-41235 Western Asia 1
Yes CA-2015-SC20725140-42182 Eastern US 1
Yes ES-2015-TP21415139-42251 Northern Europe 1
Yes CA-2015-RA19915140-42357 Western US 1
Yes ES-2014-SV2093545-41674 Western Europe 1
Yes KZ-2015-RM975068-42228 Central Asia 1
Yes KG-2015-RH955570-42340 Central Asia 1
Yes IT-2015-JS1603045-42229 Western Europe 1
Yes CA-2015-LW16990140-42336 Western US 1
Yes IN-2015-SS2059059-42236 Southeastern Asia 1
Yes IN-2012-LH1715559-40968 Southeastern Asia 1
Yes US-2015-TT21220140-42186 Western US 1
Yes SF-2015-RS9765117-42224 Southern Africa 1
Yes ID-2014-JF153557-41649 Oceania 1
Yes IT-2014-CA12310139-41961 Northern Europe 1
Yes ES-2015-SL2015545-42335 Western Europe 1
Yes IT-2014-DB1312091-41894 Western Europe 1
Yes IT-2015-DB13555139-42063 Northern Europe 1
Yes CA-2012-DB13360140-41231 Western US 1
Yes CA-2013-NW18400140-41599 Western US 1
Yes MX-2013-TB2128039-41278 Central America 1
Yes ES-2012-JC1577548-41195 Western Europe 1
Yes ES-2012-KB162408-41191 Western Europe 1
Yes IN-2014-VF2171527-41819 Eastern Asia 1
Yes MO-2015-AB60086-42173 North Africa 1
Yes ID-2012-LH1715592-41091 Oceania 1
Yes ES-2014-BP11230139-41970 Northern Europe 1
Yes IN-2015-DF1313559-42360 Southeastern Asia 1
Yes ES-2015-DK13375139-42082 Northern Europe 1
Yes US-2015-RM197505-42122 South America 1
Yes CA-2015-EH14125140-42035 Western US 1
Yes IN-2013-DR12880144-41384 Southeastern Asia 1
Yes IN-2015-RH196007-42179 Oceania 1
Yes ES-2015-JW152208-42033 Western Europe 1
Yes CA-2013-GB14530140-41583 Southern US 1
Yes IN-2015-NK1849058-42154 Southern Asia 1
Yes CA-2015-TD20995140-42118 Eastern US 1
Yes MX-2014-JR1570039-41955 Central America 1
Yes ID-2014-TB21280130-41884 Southeastern Asia 1
Yes NG-2013-NB858094-41469 Western Africa 1
Yes CA-2015-EP13915140-42316 Eastern US 1
Yes ID-2015-JC1538592-42039 Oceania 1
Yes ES-2014-AH10585139-41920 Northern Europe 1
Yes MX-2015-CR1273051-42262 Central America 1
Yes ES-2012-AB1016545-40957 Western Europe 1
Yes ES-2014-AG1039045-41685 Western Europe 1
Yes GG-2012-BS159047-41184 Western Asia 1
Yes IN-2014-DW131957-41982 Oceania 1
Yes IT-2014-BS1166562-41864 Northern Europe 1
Yes IN-2013-MY1738058-41545 Southern Asia 1
Yes MX-2012-KD1634518-40977 South America 1
Yes IT-2013-CA1205591-41545 Western Europe 1
Yes CA-2013-NF847523-41549 Western Canada 1
Yes CA-2015-SG20605140-42120 Western US 1
Yes US-2015-FW1439518-42306 South America 1
Yes SG-2015-BE1410111-42348 Western Africa 1
Yes CA-2015-LT17110140-42335 Eastern US 1
Yes US-2013-AB10105101-41446 South America 1
Yes SO-2014-GM4455116-41984 Eastern Africa 1
Yes ES-2015-NH1861048-42299 Western Europe 1
Yes CA-2013-AH10690140-41639 Central US 1
Yes ML-2013-GW460579-41403 Western Africa 1
Yes PL-2013-JF5190103-41443 Eastern Europe 1
Yes ID-2013-TC2114527-41594 Eastern Asia 1
Yes CA-2013-ES14020140-41384 Central US 1
Yes IN-2012-SC2057559-41146 Southeastern Asia 1
Yes CA-2013-SJ20215140-41461 Western US 1
Yes ES-2015-PC1900045-42227 Western Europe 1
Yes US-2013-KA1652582-41360 Central America 1
Yes IZ-2015-JM525061-42235 Western Asia 1
Yes MA-2012-TZ1144577-41037 Eastern Africa 1
Yes US-2013-CD1198055-41594 Central America 1
Yes IT-2015-JK1609048-42097 Western Europe 1
Yes ES-2013-CS1225048-41579 Western Europe 1
Yes CA-2014-BC11125140-41846 Western US 1
Yes MX-2015-CM1211528-42296 South America 1
Yes ES-2015-AM10705120-42213 Southern Europe 1
Yes US-2013-LB1679555-41462 Central America 1
Yes CA-2012-KN16390140-41244 Eastern US 1
Yes MO-2015-LA678086-42168 North Africa 1
Yes CA-2015-GM14455140-42353 Central US 1
Yes ES-2012-DM1295548-41100 Western Europe 1
Yes MX-2012-DM1301593-40971 Central America 1
Yes IN-2014-HM1486092-41679 Oceania 1
Yes ID-2015-SS205907-42361 Oceania 1
Yes IT-2013-GT14710125-41392 Western Europe 1
Yes ID-2015-MG1768092-42032 Oceania 1
Yes IN-2015-VP2173058-42024 Southern Asia 1
Yes ES-2013-HG14965120-41571 Southern Europe 1
Yes IR-2012-JF529560-40988 Southern Asia 1
Yes US-2014-KD16495140-41976 Western US 1
Yes MX-2015-FG142605-42318 South America 1
Yes ES-2012-SV20365120-41132 Southern Europe 1
Yes US-2014-DL12925101-41646 South America 1
Yes NI-2012-DV304595-41121 Western Africa 1
Yes ES-2013-GT1475545-41597 Western Europe 1
Yes ID-2014-CK1220527-41948 Eastern Asia 1
Yes ES-2013-PB18805120-41591 Southern Europe 1
Yes EG-2012-MC727538-41130 North Africa 1
Yes IN-2013-AM1070527-41535 Eastern Asia 1
Yes ES-2012-JH16180139-41090 Northern Europe 1
Yes ID-2013-TM210107-41492 Oceania 1
Yes ID-2015-CJ1187597-42147 Southern Asia 1
Yes ES-2014-TS2116045-41817 Western Europe 1
Yes CA-2014-ES14080140-41737 Eastern US 1
Yes US-2015-GT1471055-42299 Central America 1
Yes IN-2014-PW1903058-41999 Southern Asia 1
Yes ID-2012-NB1858092-41241 Oceania 1
Yes IN-2014-TS211607-41875 Oceania 1
Yes IN-2013-RH195107-41573 Oceania 1
Yes US-2015-JH1543055-42328 Central America 1
Yes US-2014-PK19075140-41907 Eastern US 1
Yes IN-2013-MG176957-41542 Oceania 1
Yes IR-2013-PK891060-41342 Southern Asia 1
Yes MX-2014-ML1775593-41795 Central America 1
Yes IT-2014-VP2173048-41990 Western Europe 1
Yes CA-2013-LS17245140-41629 Southern US 1
Yes ES-2012-BM1178545-41144 Western Europe 1
Yes PL-2012-LL6840103-41137 Eastern Europe 1
Yes IN-2014-SC205757-41662 Oceania 1
Yes CA-2012-RP19270140-41200 Western US 1
Yes SF-2013-KN6390117-41614 Southern Africa 1
Yes MX-2015-DA1345051-42180 Central America 1
Yes CA-2013-BM11575140-41532 Eastern US 1
Yes CA-2015-JC16105140-42301 Eastern US 1
Yes NI-2012-SP1086095-41090 Western Africa 1
Yes IT-2012-RS1987091-41200 Western Europe 1
Yes CA-2013-SM20950140-41627 Central US 1
Yes ES-2014-AS1009045-41885 Western Europe 1
Yes MX-2014-SK1999082-41922 Central America 1
Yes IT-2013-VW2177545-41580 Western Europe 1
Yes ES-2012-AI1085548-41187 Western Europe 1
Yes CA-2014-NZ18565140-41964 Eastern US 1
Yes ES-2015-ES1402045-42032 Western Europe 1
Yes SA-2012-LC6870110-41121 Western Asia 1
Yes ES-2012-KN16705120-41257 Southern Europe 1
Yes TU-2015-EN3780134-42164 Western Asia 1
Yes CA-2013-MS17365140-41632 Western US 1
Yes MX-2013-JC1538528-41574 South America 1
Yes RW-2015-BG1740109-42353 Eastern Africa 1
Yes MX-2015-EL1373536-42278 Caribbean 1
Yes ES-2012-JK1564048-41191 Western Europe 1
Yes IN-2015-JH159857-42221 Oceania 1
Yes CA-2012-ML17395140-41194 Eastern US 1
Yes IR-2013-CM193560-41296 Southern Asia 1
Yes MX-2015-BD1172537-42330 South America 1
Yes ES-2013-BE1133564-41387 Southern Europe 1
Yes IT-2015-Dl1360048-42209 Western Europe 1
no CA-2012-RB19435140-41236 Central US 0
Yes IR-2015-JD615060-42186 Southern Asia 1
Yes ID-2014-AG1076527-41872 Eastern Asia 1
Yes MX-2013-JM156555-41549 South America 1
Yes IT-2013-DK1298564-41618 Southern Europe 1
Yes US-2014-MH1811554-41900 Caribbean 1
Yes IN-2013-MS17710113-41495 Southeastern Asia 1
Yes ID-2014-KB16600144-41986 Southeastern Asia 1
Yes ES-2014-SC2002045-41790 Western Europe 1
Yes CA-2012-LE16810140-41258 Southern US 1
Yes CA-2015-DM13345140-42347 Western US 1
Yes CA-2014-BC11125140-41864 Eastern US 1
Yes IN-2013-NP186707-41474 Oceania 1
Yes TU-2014-JW5220134-41755 Western Asia 1
Yes CA-2014-RD19810140-41798 Eastern US 1
Yes IN-2015-JD1589558-42288 Southern Asia 1
Yes US-2014-VM21835140-41772 Western US 1
Yes MX-2013-EH1412555-41276 Central America 1
Yes EZ-2012-PS904532-41150 Eastern Europe 1
Yes CA-2013-JD15895140-41620 Western US 1
Yes CA-2014-BD11620140-41707 Eastern US 1
Yes CA-2014-JH15985140-41888 Western US 1
Yes ES-2015-PO18850139-42264 Northern Europe 1
no CG-2015-PV898533-42225 Central Africa 0
Yes MX-2013-CD1279082-41521 Central America 1
Yes US-2012-DK1283536-40939 Caribbean 1
Yes SF-2013-PF9165117-41490 Southern Africa 1
Yes MX-2014-ES1402082-41929 Central America 1
no IT-2015-RB19570120-42181 Southern Europe 0
no CA-2014-TZ1144523-41985 Eastern Canada 0
no RS-2015-BP1230108-42132 Eastern Europe 0
no CA-2015-SR20425140-42361 Southern US 0
no CA-2013-JK16120140-41551 Eastern US 0
no IN-2014-LM1706566-41893 Eastern Asia 0
no CA-2014-ON18715140-41710 Central US 0
Yes US-2014-RB19570140-41886 Central US 1
Yes MX-2014-TG216405-41952 South America 1
Yes US-2015-LR1691518-42180 South America 1
Yes NI-2015-MK790595-42144 Western Africa 1
Yes UP-2014-LL6840137-41670 Eastern Europe 1
Yes ES-2015-LT1711045-42025 Western Europe 1
Yes TU-2012-FG4260134-41177 Western Asia 1
Yes IT-2014-AT1043591-41795 Western Europe 1
Yes CA-2015-JF15415140-42367 Eastern US 1
Yes IT-2012-RD19930120-41222 Southern Europe 1
Yes IR-2014-BD162060-41820 Southern Asia 1
Yes ES-2015-CM1223545-42327 Western Europe 1
Yes MX-2015-MS1798028-42300 South America 1
Yes UP-2015-RK9300137-42341 Eastern Europe 1
Yes CA-2015-MA17560140-42298 Eastern US 1
Yes US-2013-HD1478555-41565 Central America 1
Yes MX-2013-BS1136536-41595 Caribbean 1
Yes CA-2012-RH19495140-41143 Eastern US 1
Yes ET-2014-SV1081543-41814 Eastern Africa 1
Yes MX-2013-AP1091536-41528 Caribbean 1
Yes MX-2015-RH1951082-42262 Central America 1
Yes CA-2013-JC16105140-41520 Southern US 1
Yes ES-2012-MP1817564-41187 Southern Europe 1
Yes US-2013-RR19525140-41613 Southern US 1
Yes ES-2013-GT14710139-41614 Northern Europe 1
Yes EK-2014-EP391540-41947 Central Africa 1
Yes ID-2012-TC2129527-41137 Eastern Asia 1
Yes MX-2014-TM2149039-41923 Central America 1
Yes TU-2015-EB3840134-42326 Western Asia 1
Yes MX-2013-DW1348051-41548 Central America 1
Yes US-2014-GK14620101-41744 South America 1
Yes MX-2012-PF1912028-41059 South America 1
Yes IZ-2013-GZ454561-41314 Western Asia 1
Yes CA-2015-SC20380140-42039 Southern US 1
Yes IN-2015-BS11590102-42287 Southeastern Asia 1
Yes MX-2012-MF1766582-41174 Central America 1
Yes TU-2015-CS1860134-42042 Western Asia 1
Yes MX-2013-SS2059093-41565 Central America 1
Yes MX-2015-PR1888018-42153 South America 1
Yes PL-2014-BM1650103-41888 Eastern Europe 1
Yes CA-2015-DK13090140-42279 Central US 1
Yes ID-2014-RB19330102-41767 Southeastern Asia 1
Yes MX-2013-RW1963082-41528 Central America 1
Yes IT-2012-BD1172591-40992 Western Europe 1
Yes TU-2015-SW10350134-42024 Western Asia 1
Yes US-2014-SG2008055-41769 Central America 1
Yes ES-2012-AR104058-41127 Western Europe 1
Yes CG-2015-DW358533-42341 Central Africa 1
Yes CA-2012-HP14815140-41236 Southern US 1
Yes ID-2013-AS1022559-41392 Southeastern Asia 1
Yes PL-2015-ML8265103-42252 Eastern Europe 1
Yes ES-2014-BD1132048-41992 Western Europe 1
Yes CA-2015-JH15430140-42329 Southern US 1
Yes CA-2015-NG18355140-42235 Eastern US 1
Yes MX-2012-MM1805531-40978 Caribbean 1
Yes ES-2013-EH14125120-41573 Southern Europe 1
Yes ES-2015-BM1157545-42276 Western Europe 1
Yes ES-2015-CB1202545-42041 Western Europe 1
Yes IT-2014-AP1091564-41896 Southern Europe 1
Yes ES-2012-AG1049564-41254 Southern Europe 1
Yes ID-2013-GZ14545130-41605 Southeastern Asia 1
Yes IN-2015-LH171557-42294 Oceania 1
Yes US-2015-PN18775140-42339 Southern US 1
Yes ID-2015-GD1459092-42144 Oceania 1
Yes IN-2014-IM1507058-41812 Southern Asia 1
Yes US-2012-JW1595555-41073 Central America 1
Yes MX-2014-AG1076539-41887 Central America 1
Yes ES-2015-LD1685548-42185 Western Europe 1
Yes US-2012-CW1190536-41241 Caribbean 1
Yes ID-2015-GM1445592-42334 Oceania 1
Yes EG-2013-VG1179038-41590 North Africa 1
Yes CA-2015-PN18775140-42120 Southern US 1
Yes ID-2012-RB193307-41261 Oceania 1
Yes CA-2015-AG10675140-42272 Southern US 1
Yes EN-2015-MC760542-42174 Northern Europe 1
Yes US-2014-MG1814555-41928 Central America 1
Yes CA-2015-RB19795140-42138 Western US 1
Yes IR-2014-DL286560-41950 Southern Asia 1
Yes CA-2015-PK19075140-42316 Eastern US 1
Yes ES-2014-EJ1415545-41901 Western Europe 1
Yes ES-2014-EB1397564-41814 Southern Europe 1
Yes MX-2012-JL1517582-41163 Central America 1
Yes ES-2014-CP12340120-41738 Southern Europe 1
Yes US-2015-SC2084582-42125 Central America 1
Yes TU-2013-AH585134-41367 Western Asia 1
Yes CA-2014-BM11575140-41964 Western US 1
Yes SI-2014-TC10980115-41955 Southern Europe 1
Yes ES-2012-VG2180548-41175 Western Europe 1
Yes MX-2014-Dp1324082-41960 Central America 1
Yes IN-2015-MH1744027-42025 Eastern Asia 1
Yes IN-2015-TW2102578-42063 Southeastern Asia 1
Yes IT-2015-FO1430564-42342 Southern Europe 1
Yes BO-2015-MS798013-42091 Eastern Europe 1
Yes CA-2012-ZC21910140-41271 Central US 1
Yes ES-2012-AJ1094545-41239 Western Europe 1
Yes US-2015-RL19615140-42147 Western US 1
Yes NI-2012-SN1056095-41065 Western Africa 1
Yes CA-2014-EH13945140-41655 Western US 1
Yes MX-2013-JP1552082-41440 Central America 1
Yes IN-2015-CR126257-42046 Oceania 1
Yes IN-2014-OT187307-41944 Oceania 1
Yes MX-2013-MC1759039-41577 Central America 1
Yes MX-2012-BF1127582-41039 Central America 1
Yes TU-2014-EG3900134-41794 Western Asia 1
Yes CA-2013-TC21535140-41536 Southern US 1
Yes US-2015-EB1397518-42304 South America 1
Yes ES-2015-JK1564064-42297 Southern Europe 1
Yes EG-2015-RM937538-42360 North Africa 1
Yes MX-2014-PO1886593-41642 Central America 1
Yes SA-2015-BB990110-42291 Western Asia 1
Yes US-2012-TS2108536-41070 Caribbean 1
Yes EG-2013-FA423038-41534 North Africa 1
Yes ES-2013-SC20305139-41480 Northern Europe 1
Yes CA-2013-BP11095140-41481 Western US 1
Yes MO-2013-JW607586-41520 North Africa 1
Yes ID-2015-NP18685102-42224 Southeastern Asia 1
Yes ES-2015-JC16105139-42173 Northern Europe 1
Yes US-2015-RH1955518-42079 South America 1
Yes CA-2014-WB21850140-41654 Eastern US 1
Yes IN-2013-SW202757-41585 Oceania 1
Yes MX-2013-SC2077018-41329 South America 1
Yes CA-2015-HM14980140-42122 Western US 1
Yes IR-2012-DV304560-40929 Southern Asia 1
Yes MX-2013-EJ1415516-41465 South America 1
Yes CA-2012-EJ13720140-41258 Central US 1
Yes CA-2015-SC20305140-42245 Central US 1
Yes IS-2013-MY829563-41460 Western Asia 1
Yes ID-2015-LS172007-42133 Oceania 1
Yes MX-2012-BT1130582-41158 Central America 1
Yes ES-2015-CL1189064-42356 Southern Europe 1
Yes CA-2014-JG15160140-41910 Southern US 1
Yes ID-2014-MP1747059-41709 Southeastern Asia 1
Yes SA-2013-GM4680110-41328 Western Asia 1
Yes MX-2012-TZ2158093-40955 Central America 1
Yes CA-2012-RB19645140-41143 Western US 1
Yes CA-2012-IM15055140-40932 Western US 1
Yes IN-2015-BK1126027-42341 Eastern Asia 1
Yes US-2015-DB1355598-42119 Central America 1
Yes MX-2012-AW1093031-40912 Caribbean 1
Yes MX-2014-HE1480082-41851 Central America 1
Yes US-2013-ON18715140-41411 Central US 1
Yes MX-2012-AH1046539-41185 Central America 1
Yes TU-2012-FH4365134-41121 Western Asia 1
Yes ID-2013-RW1954097-41476 Southern Asia 1
Yes CA-2014-AM10360140-41837 Central US 1
Yes CA-2013-FC14335140-41409 Eastern US 1
Yes IN-2015-IG1508566-42228 Eastern Asia 1
Yes IT-2014-EK1379591-41771 Western Europe 1
Yes ID-2015-TC2129559-42223 Southeastern Asia 1
Yes CA-2014-BD11620140-41999 Eastern US 1
Yes CA-2014-RD19900140-41960 Western US 1
Yes ID-2012-TH21100118-41125 Eastern Asia 1
Yes IZ-2014-CA205561-41816 Western Asia 1
Yes CA-2013-TC21475140-41391 Western US 1
Yes AG-2014-RD95853-41712 North Africa 1
Yes ID-2012-JE1574559-41234 Southeastern Asia 1
Yes CA-2014-TS21160140-41702 Western US 1
Yes MX-2015-DK1289526-42090 South America 1
Yes CA-2013-GB14530140-41528 Western US 1
Yes IN-2015-RD1948011-42109 Southern Asia 1
Yes ID-2015-RM197507-42129 Oceania 1
Yes US-2013-PT1909018-41418 South America 1
Yes CA-2014-AS10045140-41727 Southern US 1
Yes ES-2013-CS1246064-41368 Southern Europe 1
Yes MX-2015-SZ2003536-42216 Caribbean 1
Yes SF-2013-BD1620117-41376 Southern Africa 1
Yes TU-2013-DL2925134-41534 Western Asia 1
Yes IN-2015-DB13660102-42089 Southeastern Asia 1
Yes MX-2015-KC1625582-42259 Central America 1
Yes EG-2014-SB1018538-41944 North Africa 1
Yes ES-2015-NM18445139-42218 Northern Europe 1
Yes CM-2012-SC1068022-41009 Central Africa 1
Yes CA-2014-TB21280140-41786 Eastern US 1
Yes ES-2012-AB1060064-40927 Southern Europe 1
Yes MX-2013-JC1534082-41392 Central America 1
Yes MX-2014-CG1204031-41977 Caribbean 1
Yes UP-2014-CR2580137-41922 Eastern Europe 1
Yes NI-2015-JG516095-42235 Western Africa 1
Yes MX-2014-HP1481582-41709 Central America 1
Yes IN-2015-DK1289559-42281 Southeastern Asia 1
Yes ES-2014-SJ2021548-41998 Western Europe 1
Yes IN-2014-BS1159027-42000 Eastern Asia 1
Yes US-2013-GM14500101-41366 South America 1
Yes IN-2013-KM1666059-41574 Southeastern Asia 1
Yes ID-2014-RP1927059-41918 Southeastern Asia 1
Yes IN-2015-AS102857-42217 Oceania 1
Yes US-2013-EJ1372018-41628 South America 1
Yes IN-2015-CR128207-42270 Oceania 1
Yes US-2014-FO14305140-41944 Southern US 1
Yes SF-2012-CC2685117-41263 Southern Africa 1
Yes IT-2012-NF18385139-41237 Northern Europe 1
Yes CA-2015-EB13705140-42321 Eastern US 1
Yes US-2014-JE1574555-41971 Central America 1
Yes ES-2013-TB2162548-41374 Western Europe 1
Yes CA-2015-JS594023-42346 Eastern Canada 1
Yes IN-2015-MH1811592-42116 Oceania 1
Yes US-2013-MA1799536-41346 Caribbean 1
Yes IN-2012-JM15265144-41031 Southeastern Asia 1
Yes CA-2012-JG15115140-41189 Southern US 1
Yes US-2015-CG1252055-42316 Central America 1
Yes MX-2014-RR1931526-41951 South America 1
Yes CA-2014-CK12595140-41711 Eastern US 1
Yes MX-2014-DM1295598-41807 Central America 1
Yes MX-2012-BS1159039-41175 Central America 1
Yes MX-2012-DS1318018-41081 South America 1
Yes TU-2015-CS2355134-42101 Western Asia 1
Yes ID-2014-EB1397559-41919 Southeastern Asia 1
Yes IN-2014-AC1061558-41808 Southern Asia 1
Yes EG-2012-NM844538-41002 North Africa 1
Yes ES-2014-RB1964545-41859 Western Europe 1
Yes IN-2015-MA17995121-42230 Southern Asia 1
Yes NI-2013-EH376595-41500 Western Africa 1
Yes IR-2015-BD162060-42252 Southern Asia 1
Yes IN-2014-PB19210130-41872 Southeastern Asia 1
Yes IN-2015-AA1031558-42361 Southern Asia 1
Yes TZ-2015-BM1785129-42285 Eastern Africa 1
Yes IV-2014-LC688529-41898 Western Africa 1
Yes IN-2015-DL1292558-42167 Southern Asia 1
Yes EG-2015-NF838538-42060 North Africa 1
Yes CA-2014-ND18370140-41963 Eastern US 1
Yes NI-2012-BM114095-41061 Western Africa 1
Yes CA-2012-CM11815140-41226 Central US 1
Yes ES-2015-CJ1201064-42323 Southern Europe 1
Yes IN-2015-MB180857-42172 Oceania 1
Yes ES-2015-MJ1774045-42168 Western Europe 1
Yes ES-2015-HJ14875139-42013 Northern Europe 1
Yes CA-2012-CM11815140-41273 Central US 1
Yes CA-2014-BT11680140-41751 Eastern US 1
Yes IN-2012-GM1444027-41128 Eastern Asia 1
Yes IN-2015-DK12985144-42112 Southeastern Asia 1
Yes TU-2015-LP7080134-42185 Western Asia 1
Yes CA-2014-DP13390140-41784 Eastern US 1
Yes US-2014-AJ1078018-41752 South America 1
Yes IT-2013-BW11065139-41370 Northern Europe 1
Yes ES-2015-GG1465048-42245 Western Europe 1
Yes CA-2012-PB19150140-41254 Southern US 1
Yes CA-2014-TT21265140-41915 Eastern US 1
Yes IR-2012-SS1051560-41125 Southern Asia 1
Yes CA-2012-RA988523-41160 Eastern Canada 1
Yes US-2015-ME17320140-42322 Central US 1
Yes US-2012-GH1442598-41140 Central America 1
Yes ES-2013-EC1405048-41520 Western Europe 1
Yes US-2015-GZ14470140-42362 Western US 1
Yes MX-2014-ML1741039-41935 Central America 1
Yes MX-2012-DP1316582-41234 Central America 1
Yes MX-2012-BD1163582-41249 Central America 1
Yes MX-2015-CD1279080-42293 Caribbean 1
Yes IN-2014-DW1319559-41730 Southeastern Asia 1
Yes IN-2015-JK1612058-42126 Southern Asia 1
Yes US-2014-AR104055-41906 South America 1
Yes NI-2015-JG516095-42353 Western Africa 1
Yes US-2012-SC20260140-41165 Central US 1
Yes CA-2012-CM12715140-41177 Eastern US 1
Yes CA-2015-HM14860140-42221 Western US 1
Yes IN-2015-DK1337566-42155 Eastern Asia 1
Yes CA-2013-KC16255140-41473 Eastern US 1
Yes AL-2012-EM38252-41213 Southern Europe 1
Yes CA-2013-EH13945140-41465 Western US 1
Yes ES-2012-MZ1751545-41262 Western Europe 1
Yes US-2014-LH1675055-41840 Central America 1
Yes MX-2015-LA1678051-42286 Central America 1
Yes ID-2014-LB167957-41829 Oceania 1
Yes CA-2015-LW17215140-42348 Central US 1
Yes ES-2015-AM10705120-42017 Southern Europe 1
Yes TU-2014-SD10485134-41771 Western Asia 1
Yes US-2012-AH1046536-41234 Caribbean 1
Yes US-2012-DB1327036-41021 Caribbean 1
Yes CA-2014-LS16945140-41912 Eastern US 1
Yes MX-2015-QJ1925551-42255 Central America 1
Yes ES-2015-AS1004564-42028 Southern Europe 1
Yes SG-2015-AG495111-42164 Western Africa 1
Yes CA-2012-KC16675140-41255 Southern US 1
Yes CA-2015-JB16045140-42362 Eastern US 1
Yes ZA-2015-RC9960146-42257 Eastern Africa 1
Yes ES-2012-TB21190139-40992 Northern Europe 1
Yes US-2013-GA1472598-41599 Central America 1
Yes US-2013-TS2134055-41356 Central America 1
Yes CA-2015-EH13765140-42027 Central US 1
Yes TU-2015-SC10050134-42216 Western Asia 1
Yes CA-2014-CY12745140-41867 Western US 1
Yes KG-2015-FO430570-42318 Central Asia 1
Yes GH-2015-KD661549-42183 Western Africa 1
Yes IT-2015-DK12895124-42312 Northern Europe 1
Yes CA-2013-DP13165140-41557 Central US 1
Yes CA-2015-SP20860140-42276 Southern US 1
Yes IN-2015-RH1949559-42257 Southeastern Asia 1
Yes CA-2013-BN11470140-41380 Eastern US 1
Yes NI-2013-EH412595-41541 Western Africa 1
Yes ID-2013-PB18805130-41421 Southeastern Asia 1
Yes TU-2015-SV10785134-42340 Western Asia 1
Yes US-2014-DJ1363018-41963 South America 1
Yes US-2015-JE15610140-42321 Western US 1
Yes ID-2014-RH1949559-41984 Southeastern Asia 1
Yes IN-2014-AJ109457-41793 Oceania 1
Yes CA-2012-LT16765140-41152 Western US 1
Yes IN-2012-ST2053058-41058 Southern Asia 1
Yes CA-2012-PJ19015140-41005 Southern US 1
Yes MX-2014-DK1298518-41740 South America 1
Yes ID-2014-SC2026092-41894 Oceania 1
Yes UP-2013-DL2925137-41299 Eastern Europe 1
Yes AE-2014-MY7380138-42004 Western Asia 1
Yes ES-2015-LS1723045-42159 Western Europe 1
Yes TU-2014-MY8295134-41860 Western Asia 1
Yes MX-2014-KN1639082-41907 Central America 1
Yes IT-2013-CA12310139-41538 Northern Europe 1
Yes CA-2014-LF17185140-41933 Eastern US 1
Yes CA-2015-SJ20125140-42105 Eastern US 1
Yes US-2013-DR12940140-41635 Central US 1
Yes TU-2014-TC11145134-41656 Western Asia 1
Yes MX-2012-RE1940539-41195 Central America 1
Yes ES-2013-ME1772545-41370 Western Europe 1
Yes CA-2013-MS17830140-41478 Eastern US 1
Yes IN-2015-DB13405144-42341 Southeastern Asia 1
Yes US-2015-SC20050140-42278 Central US 1
Yes IN-2014-DM1301527-41919 Eastern Asia 1
Yes CA-2014-DL13330140-41941 Eastern US 1
Yes MX-2012-AH1012082-41226 Central America 1
Yes NG-2015-JC577594-42260 Western Africa 1
Yes CA-2014-MG17890140-41703 Western US 1
Yes EG-2014-CS186038-41690 North Africa 1
Yes US-2012-KT16465140-41168 Southern US 1
Yes NI-2013-DB321095-41521 Western Africa 1
Yes CA-2013-PS19045140-41438 Eastern US 1
Yes TU-2015-AG675134-42099 Western Asia 1
Yes US-2015-SH1997555-42052 Central America 1
Yes IT-2014-DO1364591-41870 Western Europe 1
Yes ES-2013-BF1100591-41501 Western Europe 1
Yes US-2012-JA1597055-41237 Central America 1
Yes TU-2013-CR2730134-41324 Western Asia 1
Yes RO-2015-SA10830107-42012 Eastern Europe 1
Yes MX-2015-NF1859539-42209 Central America 1
Yes NI-2014-JK562595-41779 Western Africa 1
Yes MX-2015-SP2092055-42363 Central America 1
Yes MX-2014-EH1418518-41915 South America 1
Yes MX-2014-KL1664593-41733 Central America 1
Yes NI-2015-BP105095-42249 Western Africa 1
Yes CA-2015-ML17410140-42025 Central US 1
Yes IN-2015-AH1069027-42181 Eastern Asia 1
Yes IN-2015-BE1141027-42249 Eastern Asia 1
Yes TU-2015-JD6015134-42327 Western Asia 1
Yes IN-2013-AS1028558-41354 Southern Asia 1
Yes US-2012-GR1456054-41082 Caribbean 1
Yes CA-2014-AB10255140-41936 Western US 1
Yes BN-2014-KB631515-41904 Western Africa 1
Yes CA-2015-BD11725140-42276 Western US 1
Yes KZ-2012-PR888068-41144 Central Asia 1
Yes CA-2015-SC20575140-42236 Central US 1
Yes CA-2015-GK14620140-42257 Central US 1
Yes ZA-2015-MN7935147-42339 Eastern Africa 1
Yes ES-2012-AA1064564-41268 Southern Europe 1
Yes IN-2015-MO178007-42363 Oceania 1
Yes CA-2013-AI10855140-41628 Western US 1
Yes ES-2015-WB21850139-42248 Northern Europe 1
Yes AG-2014-CM21603-41755 North Africa 1
Yes IN-2012-RC198257-41167 Oceania 1
Yes IN-2013-JM152657-41576 Oceania 1
Yes TU-2012-PF9165134-41074 Western Asia 1
Yes US-2012-TH21235140-41216 Western US 1
Yes US-2013-PF1916582-41445 Central America 1
Yes CA-2015-AA10645140-42314 Western US 1
Yes ES-2012-MO17950120-41137 Southern Europe 1
Yes ES-2013-PB1915034-41373 Northern Europe 1
Yes NI-2014-CG204095-41856 Western Africa 1
Yes NI-2015-EB411095-42174 Western Africa 1
Yes IN-2014-KD16345144-41768 Southeastern Asia 1
Yes IN-2015-LA16780102-42095 Southeastern Asia 1
Yes IN-2014-SE2011066-41772 Eastern Asia 1
Yes ES-2015-AS1024064-42297 Southern Europe 1
Yes ZA-2014-LS6945147-41672 Eastern Africa 1
Yes TU-2014-SF10965134-41992 Western Asia 1
Yes US-2014-LB16795140-41957 Central US 1
Yes IN-2014-DA1345058-41769 Southern Asia 1
Yes US-2013-HG14845140-41530 Eastern US 1
Yes US-2013-SJ2021582-41543 Central America 1
Yes CA-2015-EB13870140-42269 Eastern US 1
Yes EG-2014-PM894038-41846 North Africa 1
 PRACTICE
1
1 IF IT IS RETURNED
1 YES 1 RETURNED ORDERS
1 NO 0 YES 1042
1 NO 37
0 IF(A2="Yes",1,0)
1
1 COUNT(D2:D1080) COUNT(A:A) COUNTA(A2:A1080)
0 count of all 1079 0 1079
1 count of 1 1042 COUNTIF(D2:D1080,"1")
1 count of 0 37 COUNTIF(D2:D1080,"0")
1
1
0 Central US total 1 COUNTIFS(C2:C1080,"central us",D2:D1080,"1")
0 Central US total 0 COUNTIFS(C3:C1080,"central us",D3:D1080,"0")
1
0
1 Eastern Asia total 1 COUNTIFS(C2:C1080,C3,D2:D1080,D2)
1 Eastern Asia total 0 COUNTIFS(C2:C1080,C3,D2:D1080,D7)
0
0
0
1
0
1
0
1
1
0
1
0
1
0
1
0
1
0
1
1
1
1
1
1
0
0
0
0
1
1
1
1
1
1
1
1
1
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
0
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
 COUNTA(A2:A1080)

ntral us",D2:D1080,"1")
ntral us",D3:D1080,"0")

D2:D1080,D2)
D2:D1080,D7)
 Region
Central US

Returned Order ID Region

RETURNED ORDERS
Yes CA-2012-SA20830140-41210 Central US 1
Yes CA-2012-SC20095140-41174 Central US 1
Yes CA-2014-TB21280140-41724 Central US 1
Yes US-2012-CV12295140-40995 Central US 1
Yes CA-2013-IM15070140-41459 Central US 1
Yes CA-2014-BM11785140-41835 Central US 1
Yes CA-2014-NS18505140-41968 Central US 1
Yes CA-2014-SN20560140-41817 Central US 1
Yes CA-2012-MC17425140-41058 Central US 1
Yes US-2014-BG11695140-42001 Central US 1
Yes CA-2012-AG10525140-41153 Central US 1
Yes CA-2015-AJ10945140-42248 Central US 1
no US-2015-EB13930140-42208 Central US 0
no CA-2013-AG10495140-41571 Central US 0
no US-2015-LH16900140-42348 Central US 0
no CA-2013-MV17485140-41450 Central US 0
Yes CA-2013-AH10690140-41639 Central US 1
Yes CA-2013-ES14020140-41384 Central US 1
Yes CA-2015-GM14455140-42353 Central US 1
Yes CA-2013-SM20950140-41627 Central US 1
no CA-2012-RB19435140-41236 Central US 0
no CA-2014-ON18715140-41710 Central US 0
Yes US-2014-RB19570140-41886 Central US 1
Yes CA-2015-DK13090140-42279 Central US 1
Yes CA-2012-ZC21910140-41271 Central US 1
Yes CA-2012-EJ13720140-41258 Central US 1
Yes CA-2015-SC20305140-42245 Central US 1
Yes US-2013-ON18715140-41411 Central US 1
Yes CA-2014-AM10360140-41837 Central US 1
Yes CA-2012-CM11815140-41226 Central US 1
Yes CA-2012-CM11815140-41273 Central US 1
Yes US-2015-ME17320140-42322 Central US 1
Yes US-2012-SC20260140-41165 Central US 1
Yes CA-2015-LW17215140-42348 Central US 1
Yes CA-2015-EH13765140-42027 Central US 1
Yes CA-2013-DP13165140-41557 Central US 1
Yes US-2013-DR12940140-41635 Central US 1
Yes US-2015-SC20050140-42278 Central US 1
Yes CA-2015-ML17410140-42025 Central US 1
Yes CA-2015-SC20575140-42236 Central US 1
Yes CA-2015-GK14620140-42257 Central US 1
Yes US-2014-LB16795140-41957 Central US 1
 RANK PERFORMANCE OF Emplyoee PRACTICE
IF(A2=1,"outst
good
1 OUTSTANDING
IF(A2<=1,"outs
2 EXCELLENT goo
3 VERY GOOD
1 OUTSTANDING
5 AVERAGE
6 AVERAGE
4 GOOD
1 OUTSTANDING
1 OUTSTANDING
2 EXCELLENT
7 AVERAGE
6 AVERAGE

IF IT >= TO 500 THEN VERY GOOD , IF IT IS >= 300 THEN IT IS GOOD , IF IT IS LESS 300 POOR
NUMBERS FORMULA ALREDY GIVEN PRACTICE FORMULA ALREDY GIVEN
500 VERY GOOD VERY GOOD
600 VERY GOOD VERY GOOD
300 POOR GOOD
400 POOR GOOD
500 VERY GOOD VERY GOOD
250 POOR POOR
350 POOR GOOD
650 VERY GOOD VERY GOOD
700 VERY GOOD VERY GOOD
150 POOR POOR
IF(A2=1,"outstanding",IF(A2=2,"excellent",IF(A2=3,"very
good",IF(A2=4,"good","average"))))

IF(A2<=1,"outstanding",IF(A2<=2,"excellent",IF(A2<=3,"very
good",IF(A2<=4,"good","average"))))

if logical operators THESE CONDITION YOU WILL APPLY FOR C

< THESE CONDITION YOU WILL APPLY FOR C
>
=
<=
>=

, IF IT IS LESS 300 POOR

PRACTICE
IF(B17>=500,"VERY GOOD",IF(B17>=300,"GOOD","POOR"))

IF(B17>=500,"VERY GOOD","POOR")

2
ION YOU WILL APPLY FOR CONDITIONAL FORMATTING
ION YOU WILL APPLY FOR CUSTOM FORMATTING
MONTH SALES
JAN 2000
JAN 3000
FEB four thousand HOW MANY 0 ARE THERE 0
FEB 5000
JAN 11000 SINGLE
JAN
FEB 12000 COUNTIF
JAN TWO THOUSAND count how many values are there more than

3
FEB 2500
count how many values are EQUAL & MORE THA
FEB 3500
5
JAN 4500 HOW MANY JAN ARE THERE
JAN 8000 13
FEB 1200
JAN
FEB

JAN four thousand COUNTA TOTAL VALUE INCLUDING TEXT (COUNTA)

JAN 500 COUNT TOTAL VALUES ( COUNT)

FEB 250 COUNTBLANK HOW MANY BLANK CELLS ARE THERE

FEB
JAN 450 COUNT FEB
JAN
JAN 80
E MULTIPLE
F COUNTIFS
here more than 5000 MORE THAN 5000 IN ONLY JAN

UAL & MORE THAN 4000 count how many values are EQUAL & MORE THAN 4000 IN FEB
2
ARE THERE COUNT how many values are MORE THAN 5000 AND LESS THAN 1
1

23
 mon

MULTIPLE
COUNTIFS
AN 5000 IN ONLY JAN

are EQUAL & MORE THAN 4000 IN FEB

MORE THAN 5000 AND LESS THAN 10000

YEAR MONTH SALES TOTAL SUM
2019 JAN 2000 SUMIF
2020 JAN 3000 FEB SUM OF ONLY JAN
2019 FEB 5000 JAN

2020 FEB 5000 2019 SUMIFS

2020 JAN 11000 SUM OF JAN FOR YEAR 2019
2019 JAN SUM OF Feb FOR YEAR 2019
2020 FEB 12000

2019 JAN 2500 AVERAGE

2019 FEB TOTAL AVERAGE
2020 JAN

2020 FEB 2500 AVERAGEIF

2020 FEB 3500 AVERAGE OF ONLY JAN
2019 JAN 4500

2019 JAN 8000 AVERAGEIFS

2020 FEB 1200 AVERAGE OF JAN FOR THE YEAR 2019
2019 JAN

2019 FEB

2019 JAN 50000

2020 JAN 500

2019 FEB 2500

2020 FEB

2020 JAN 450

2019 JAN

2020 JAN 80
 113730
82030 SATISTICAL FUNCTION
82030 count sum average
10 10 10
20 20 20
67000 30 30 30
7500 40 40 40
50 50 50
5 150 30
6690 COUNT(I4:I8) SUM(J4:J8) AVERAGE(K4:K8)
countif sumif averageif
countfs sumifs averageifs
8203 JAN FEB
4528.5714286 SUM OF TOTAL SALES 82030 31700

13400 SUM OF JAN FOR YEAR 2019

SUMIFS(C:C,A:A,"2019",B:B,"JAN") SUMIF(B:B,"JAN",C:C)
,"JAN",C:C)