Spoiler (Highlight to read) I want help with Microsoft excel average function. Please help me with following conditions in excel.Data is attached below.1What is the average total USD rev/parent?2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10 Data All rev in USD Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D1b12017-12-01 -> 2017-12-0100.19002b12017-12-18 -> 2017-12-18000.3103b12017-12-07 -> 2017-12-07000.4604b22017-12-24 -> 2017-12-25001.0705b32017-12-06 -> 2017-12-20001.1806b32017-12-24 -> 2017-12-29001.4701b12017-12-01 -> 2017-12-01002.1802b12017-12-01 -> 2017-12-01002.6903b12017-12-26 -> 2017-12-30002.9704b22017-12-01 -> 2017-12-01002.9905b32017-12-19 -> 2017-12-30004.2706b32017-12-21 -> 2017-12-22005.0107b72017-12-29 -> 2017-12-30006.8201b12017-12-01 -> 2017-12-02006.7901b12017-12-01 -> 2017-12-23008.65012b82017-12-16 -> 2017-12-17008.91017b92017-12-18 -> 2017-12-3109.720018b92017-12-01 -> 2017-12-01010.520019b102017-12-01 -> 2017-12-030011.26020b102017-12-08 -> 2017-12-31011.360021b112017-12-24 -> 2017-12-270012.93022b112017-12-07 -> 2017-12-090013.61023b22017-12-01 -> 2017-12-040013.99024b22017-12-22 -> 2017-12-220014.41025b132017-12-17 -> 2017-12-210015.49026b132017-12-13 -> 2017-12-260015.58027b142017-12-01 -> 2017-12-300015.59028b142017-12-01 -> 2017-12-140015.67029b32017-12-30 -> 2017-12-3116.1300030b32017-12-01 -> 2017-12-070016.09031b162017-12-07 -> 2017-12-07019.070032b162017-12-01 -> 2017-12-030019.67033b172017-12-04 -> 2017-12-26020.980034b172017-12-06 -> 2017-12-1021.4200035b42017-12-02 -> 2017-12-0508.6713.43036b42017-12-20 -> 2017-12-230022.66037b192017-12-12 -> 2017-12-190022.59038b192017-12-21 -> 2017-12-300021.551.8839b202017-12-28 -> 2017-12-3023.4900040b202017-12-05 -> 2017-12-120023.31041b212017-12-28 -> 2017-12-310024.07042b212017-12-07 -> 2017-12-160021.283.1243b222017-12-01 -> 2017-12-020024.79044b62017-12-21 -> 2017-12-31025.070045b72017-12-01 -> 2017-12-050024.83046b232017-12-07 -> 2017-12-2200620.04047b242017-12-04 -> 2017-12-05024.820048b242017-12-15 -> 2017-12-190025.52049b252017-12-12 -> 2017-12-170025.58050b252017-12-01 -> 2017-12-030025.93051b262017-12-08 -> 2017-12-110026.13052b262017-12-13 -> 2017-12-170026.45053b272017-12-06 -> 2017-12-130026.4054b272017-12-16 -> 2017-12-160026.82055b282017-12-01 -> 2017-12-040026.78056b282017-12-11 -> 2017-12-13027.890057b292017-12-21 -> 2017-12-260028.96058b292017-12-01 -> 2017-12-300027.321.8859b302017-12-10 -> 2017-12-120029.77060b302017-12-03 -> 2017-12-090030.21061b312017-12-07 -> 2017-12-23455.2600062b312017-12-01 -> 2017-12-170031.02063b322017-12-21 -> 2017-12-280032.49064b322017-12-01 -> 2017-12-0532.900065b332017-12-01 -> 2017-12-030033.08066b332017-12-07 -> 2017-12-190034.12067b342017-12-04 -> 2017-12-300035.22068b342017-12-01 -> 2017-12-03035.30069b352017-12-01 -> 2017-12-150036.97070b352017-12-12 -> 2017-12-180037.68071b362017-12-08 -> 2017-12-120038.29072b362017-12-16 -> 2017-12-19039.70073b372017-12-21 -> 2017-12-300041.7074b372017-12-01 -> 2017-12-300041.51075b382017-12-01 -> 2017-12-090046.48076b382017-12-27 -> 2017-12-290047.58077b392017-12-04 -> 2017-12-280034.9213.1678b392017-12-01 -> 2017-12-2002.5325.4120.8679b402017-12-01 -> 2017-12-040050.25080b402017-12-13 -> 2017-12-160050.56081b412017-12-01 -> 2017-12-040051.46082b412017-12-15 -> 2017-12-180053.82083b422017-12-07 -> 2017-12-180053.75084b422017-12-01 -> 2017-12-2303.5150.67085b432017-12-05 -> 2017-12-200048.355.9186b432017-12-20 -> 2017-12-300054.79087b442017-12-01 -> 2017-12-050054.66088b442017-12-01 -> 2017-12-090055.91089b452017-12-07 -> 2017-12-080056.03090b452017-12-01 -> 2017-12-070056.24091b462017-12-05 -> 2017-12-100056.671.5592b462017-12-20 -> 2017-12-2658.9500093b472017-12-01 -> 2017-12-20058.880094b472017-12-01 -> 2017-12-080059.19095b482017-12-28 -> 2017-12-310060.6096b482017-12-01 -> 2017-12-070060.39097b492017-12-01 -> 2017-12-150061.13098b492017-12-04 -> 2017-12-300062.87099b502017-12-04 -> 2017-12-060065.060100b502017-12-06 -> 2017-12-280065.520101b512017-12-01 -> 2017-12-150065.510102b512017-12-15 -> 2017-12-270066.780103b522017-12-01 -> 2017-12-180069.390104b522017-12-10 -> 2017-12-260070.560105b532017-12-01 -> 2017-12-120021.3549.68106b532017-12-01 -> 2017-12-090071.140107b542017-12-01 -> 2017-12-300072.490108b542017-12-01 -> 2017-12-300073.270109b552017-12-01 -> 2017-12-300073.530110b552017-12-01 -> 2017-12-220075.240111b562017-12-27 -> 2017-12-300075.770112b562017-12-03 -> 2017-12-150075.20113b572017-12-01 -> 2017-12-030077.820114b572017-12-01 -> 2017-12-070078.270115b582017-12-01 -> 2017-12-19078.500116b582017-12-01 -> 2017-12-190079.010117b592017-12-12 -> 2017-12-160079.330118b592017-12-26 -> 2017-12-300080.540119b602017-12-01 -> 2017-12-250081.060120b602017-12-21 -> 2017-12-300083.370121b612017-12-11 -> 2017-12-31084.8100.31122b612017-12-29 -> 2017-12-300086.130123b622017-12-04 -> 2017-12-170086.50124b622017-12-01 -> 2017-12-28087.700125b632017-12-01 -> 2017-12-31087.9300126b632017-12-01 -> 2017-12-050089.580127b642017-12-05 -> 2017-12-300091.980128b642017-12-22 -> 2017-12-300097.140129b652017-12-01 -> 2017-12-100098.350130b652017-12-01 -> 2017-12-050098.780131b662017-12-21 -> 2017-12-3100101.050132b662017-12-14 -> 2017-12-16000204.03133b672017-12-04 -> 2017-12-130096.245.28134b672017-12-28 -> 2017-12-3174.84029.570135b682017-12-07 -> 2017-12-200060.5344.7136b682017-12-01 -> 2017-12-2700107.930137b692017-12-01 -> 2017-12-2500110.990138b692017-12-26 -> 2017-12-3000112.180139b702017-12-09 -> 2017-12-1900113.50140b702017-12-01 -> 2017-12-3000116.890141b712017-12-07 -> 2017-12-31024.8391.921.87142b712017-12-01 -> 2017-12-1600119.310143b722017-12-11 -> 2017-12-3000120.410144b722017-12-01 -> 2017-12-1100121.480145b732017-12-01 -> 2017-12-3001.83121.440146b732017-12-11 -> 2017-12-280100.61028.38147b742017-12-01 -> 2017-12-31046.5683.410148b742017-12-20 -> 2017-12-3000132.120149b752017-12-01 -> 2017-12-2300132.280150b752017-12-08 -> 2017-12-3005.41121.310.29151b762017-12-01 -> 2017-12-1700137.460152b762017-12-20 -> 2017-12-3000139.820153b772017-12-01 -> 2017-12-0900138.770154b772017-12-30 -> 2017-12-31070.5772.230155b782017-12-01 -> 2017-12-1200143.870156b782017-12-05 -> 2017-12-2400145.860157b792017-12-12 -> 2017-12-3000146.530.31158b792017-12-01 -> 2017-12-1100146.980159b802017-12-17 -> 2017-12-3000156.590160b802017-12-02 -> 2017-12-30049.72107.230161b812017-12-01 -> 2017-12-2500160.80.31162b812017-12-01 -> 2017-12-3000161.510163b822017-12-02 -> 2017-12-1304.84157.720164b822017-12-29 -> 2017-12-3008.29156.160165b832017-12-01 -> 2017-12-1900164.60166b832017-12-15 -> 2017-12-2900167.461.87167b842017-12-01 -> 2017-12-3000169.980168b842017-12-21 -> 2017-12-2900172.240169b852017-12-01 -> 2017-12-11170.76000170b852017-12-01 -> 2017-12-21139.34038.460171b862017-12-01 -> 2017-12-2500177.510172b862017-12-10 -> 2017-12-1900179.610173b872017-12-19 -> 2017-12-3103.5178.50174b872017-12-27 -> 2017-12-30097.2590.620175b882017-12-01 -> 2017-12-3100187.10176b882017-12-01 -> 2017-12-310192.9600177b892017-12-01 -> 2017-12-3100179.8913.08178b892017-12-04 -> 2017-12-070192.4500179b902017-12-01 -> 2017-12-1500192.590180b902017-12-01 -> 2017-12-2900200.830181b912017-12-01 -> 2017-12-2700210.430182b912017-12-13 -> 2017-12-3000212.940183b922017-12-15 -> 2017-12-2500214.480184b922017-12-01 -> 2017-12-080065.89152.68185b932017-12-18 -> 2017-12-3000231.980186b932017-12-06 -> 2017-12-2989.710142.310187b942017-12-11 -> 2017-12-2900236.690188b942017-12-01 -> 2017-12-1100238.180189b952017-12-15 -> 2017-12-2700243.220190b952017-12-01 -> 2017-12-3000243.020191b962017-12-01 -> 2017-12-3100245.750192b962017-12-01 -> 2017-12-18246.13000193b972017-12-12 -> 2017-12-3000248.850194b972017-12-01 -> 2017-12-070252.2100195b982017-12-16 -> 2017-12-3000264.760196b982017-12-01 -> 2017-12-2300266.30197b992017-12-01 -> 2017-12-2900269.460198b992017-12-01 -> 2017-12-1800270.020199b1002017-12-01 -> 2017-12-30095.01177.660200b1002017-12-15 -> 2017-12-2100271.291.88201b1012017-12-01 -> 2017-12-2000277.780202b1012017-12-01 -> 2017-12-2200279.470203b1022017-12-20 -> 2017-12-2500075.18204b1022017-12-01 -> 2017-12-300127.97153.830205b1032017-12-01 -> 2017-12-1100282.80206b1032017-12-06 -> 2017-12-2300285.460207b1042017-12-10 -> 2017-12-3000291.490208b1042017-12-21 -> 2017-12-2700285.279.19209b1052017-12-13 -> 2017-12-3000302.520210b1052017-12-01 -> 2017-12-1700305.730211b1062017-12-23 -> 2017-12-300052.3914.76212b1062017-12-23 -> 2017-12-2701.75310.110213b1072017-12-18 -> 2017-12-2700311.40214b1072017-12-18 -> 2017-12-2700311.320215b1082017-12-22 -> 2017-12-280065.130216b1082017-12-11 -> 2017-12-2700310.360217b1092017-12-05 -> 2017-12-2700064.13218b1092017-12-13 -> 2017-12-2700310.330219b1102017-12-22 -> 2017-12-290062.340220b1102017-12-07 -> 2017-12-2700310.010221b1102017-12-12 -> 2017-12-2508.27301.720222b1102017-12-19 -> 2017-12-2900312.990223b1102017-12-13 -> 2017-12-3000312.480224b1102017-12-07 -> 2017-12-19010.44300.810225b1102017-12-11 -> 2017-12-2900312.250226b1102017-12-01 -> 2017-12-2200290.7528.19227b1102017-12-05 -> 2017-12-2800057.98228b1102017-12-01 -> 2017-12-3000328.670229b1102017-12-01 -> 2017-12-2900331.340.31230b1152017-12-01 -> 2017-12-13330.83000231b1162017-12-01 -> 2017-12-1700334.370232b1162017-12-05 -> 2017-12-3000339.490233b1172017-12-01 -> 2017-12-2100341.890234b1172017-12-01 -> 2017-12-31342.5000235b1182017-12-01 -> 2017-12-1500349.60236b1182017-12-01 -> 2017-12-2600350.660237b1192017-12-01 -> 2017-12-1800355.260238b1192017-12-22 -> 2017-12-290051.190239b1202017-12-01 -> 2017-12-3100359.320240b1202017-12-01 -> 2017-12-3100360.110.31241b1212017-12-01 -> 2017-12-23362.68000242b1212017-12-01 -> 2017-12-110373.2100243b1222017-12-06 -> 2017-12-170379.2800244b1222017-12-07 -> 2017-12-090047.310245b1232017-12-15 -> 2017-12-2700384.190246b1232017-12-01 -> 2017-12-310383.2700247b1242017-12-01 -> 2017-12-310216169.810248b1242017-12-07 -> 2017-12-2900041.3249b1252017-12-22 -> 2017-12-280039.740250b1252017-12-01 -> 2017-12-160386.1100251b1262017-12-22 -> 2017-12-270039.560252b1262017-12-20 -> 2017-12-2600389.360253b1272017-12-01 -> 2017-12-270172.79240.490254b1272017-12-01 -> 2017-12-31302.8815.6499.260255b1282017-12-22 -> 2017-12-290036.420256b1282017-12-22 -> 2017-12-300035.990257b1292017-12-01 -> 2017-12-270418.2400258b1292017-12-22 -> 2017-12-3100422.780259b1302017-12-01 -> 2017-12-2700420.820260b1302017-12-01 -> 2017-12-140193.11115.78119.33261b1312017-12-01 -> 2017-12-3000430.70262b1312017-12-01 -> 2017-12-2900451.880263b1322017-12-01 -> 2017-12-1600451.480264b1322017-12-01 -> 2017-12-28088.88374.380265b1332017-12-01 -> 2017-12-150462.4600266b1332017-12-01 -> 2017-12-2500463.910267b1342017-12-14 -> 2017-12-1900028.99268b1342017-12-24 -> 2017-12-2700470.190269b1352017-12-12 -> 2017-12-3100469.010270b1352017-12-05 -> 2017-12-2996.05336.9334.970271b1362017-12-06 -> 2017-12-2600026.8272b1362017-12-05 -> 2017-12-2800468.290273b1372017-12-07 -> 2017-12-27034.98433.830274b1372017-12-09 -> 2017-12-31386.84096.270275b1382017-12-01 -> 2017-12-3000485.570276b1382017-12-19 -> 2017-12-3000026277b1392017-12-01 -> 2017-12-2900511.510278b1392017-12-01 -> 2017-12-300105.97408.640.99279b1402017-12-14 -> 2017-12-280509.5233.470280b1402017-12-01 -> 2017-12-3000539.139.69281b1412017-12-01 -> 2017-12-290264.29367.120282b1412017-12-16 -> 2017-12-3103.14685.760283b1422017-12-15 -> 2017-12-2900699.810284b1422017-12-01 -> 2017-12-31046.53694.210285b1432017-12-05 -> 2017-12-3100743.390286b1432017-12-01 -> 2017-12-3000743.580287b1442017-12-01 -> 2017-12-230743.7900288b1442017-12-01 -> 2017-12-240399.4369.640289b1452017-12-01 -> 2017-12-2100023.31290b1452017-12-01 -> 2017-12-3000780.930291b1462017-12-01 -> 2017-12-3000787.070292b1462017-12-19 -> 2017-12-270789.7600293b1472017-12-05 -> 2017-12-2200791.070294b1472017-12-28 -> 2017-12-2900815.290295b1482017-12-22 -> 2017-12-300020.790296b1482017-12-01 -> 2017-12-3000020.19297b1492017-12-01 -> 2017-12-2600020.03298b1492017-12-01 -> 2017-12-270768.4289.310299b1502017-12-01 -> 2017-12-300772.85126.210300b1502017-12-22 -> 2017-12-300018.580301b1512017-12-09 -> 2017-12-2100018.33302b1512017-12-29 -> 2017-12-300017.540303b1522017-12-22 -> 2017-12-300016.280304b1522017-12-01 -> 2017-12-3000912.630305b1532017-12-12 -> 2017-12-27389.43264.39281.80306b1532017-12-01 -> 2017-12-2900951.010307b1542017-12-01 -> 2017-12-30001013.890308b1542017-12-01 -> 2017-12-27001012.948.8309b1552017-12-06 -> 2017-12-3000015.54310b1552017-12-01 -> 2017-12-2800871.33164.55311b1562017-12-01 -> 2017-12-230101.15881.6862.08312b1562017-12-01 -> 2017-12-3100014.41313b1572017-12-12 -> 2017-12-2801171.3800314b1572017-12-26 -> 2017-12-290013.970315b1582017-12-01 -> 2017-12-30001170.80316b1582017-12-28 -> 2017-12-3000013.46317b1592017-12-04 -> 2017-12-2100013.37318b1592017-12-22 -> 2017-12-280013.170319b1602017-12-09 -> 2017-12-1701168.2600320b1602017-12-11 -> 2017-12-1200012.74321b1612017-12-01 -> 2017-12-2800011.88322b1612017-12-08 -> 2017-12-2700011.54323b1622017-12-22 -> 2017-12-270011.410324b1622017-12-01 -> 2017-12-27001131.6951.23325b1632017-12-01 -> 2017-12-30001356.930326b1632017-12-11 -> 2017-12-2800010.93327b1642017-12-01 -> 2017-12-2501472.2900328b1642017-12-14 -> 2017-12-1400010.26329b1652017-12-01 -> 2017-12-23001506.30330b1652017-12-29 -> 2017-12-300009.72331b1662017-12-01 -> 2017-12-30001561.10332b1662017-12-22 -> 2017-12-29008.860333b1672017-12-02 -> 2017-12-240875.59686.30334b1672017-12-28 -> 2017-12-28008.550335b1682017-12-25 -> 2017-12-280008.15336b1682017-12-02 -> 2017-12-110008.07337b1692017-12-06 -> 2017-12-220007.78338b1692017-12-12 -> 2017-12-300007.78339b1702017-12-19 -> 2017-12-260007.51340b1702017-12-18 -> 2017-12-280007.19341b1712017-12-06 -> 2017-12-180006.89342b1712017-12-19 -> 2017-12-31022.161566.320343b1722017-12-01 -> 2017-12-2901268.35391.210344b1722017-12-01 -> 2017-12-290006.54345b1732017-12-27 -> 2017-12-270005.92346b1732017-12-22 -> 2017-12-30005.840347b1742017-12-22 -> 2017-12-23005.780348b1742017-12-04 -> 2017-12-310005.61349b1752017-12-23 -> 2017-12-240005.33350b1752017-12-21 -> 2017-12-220005.32351b1762017-12-12 -> 2017-12-210005.31352b1762017-12-01 -> 2017-12-290625.61363.140353b1772017-12-01 -> 2017-12-300005354b1772017-12-01 -> 2017-12-310004.89355b1782017-12-11 -> 2017-12-290004.67356b1782017-12-04 -> 2017-12-210004.66357b1792017-12-07 -> 2017-12-110004.35358b1792017-12-07 -> 2017-12-140004.35359b1802017-12-04 -> 2017-12-070004.35360b1802017-12-01 -> 2017-12-030004.34361b1812017-12-01 -> 2017-12-31002071.820362b1812017-12-30 -> 2017-12-300004.08363b1822017-12-22 -> 2017-12-270004.07364b1822017-12-06 -> 2017-12-240004.06365b1832017-12-05 -> 2017-12-280004.05366b1832017-12-27 -> 2017-12-30003.890367b1842017-12-22 -> 2017-12-270003.76368b1842017-12-01 -> 2017-12-010003.72369b1852017-12-07 -> 2017-12-310003.71370b1852017-12-30 -> 2017-12-300003.45371b1862017-12-22 -> 2017-12-270003.45372b1862017-12-21 -> 2017-12-210003.45373b1872017-12-13 -> 2017-12-290003.42374b1872017-12-29 -> 2017-12-300003.13375b1882017-12-19 -> 2017-12-190003.12376b1882017-12-13 -> 2017-12-240003.12377b1892017-12-14 -> 2017-12-260003.11378b1892017-12-01 -> 2017-12-2602103.3900379b1902017-12-21 -> 2017-12-30019.332349.750380b1902017-12-01 -> 2017-12-310002.81381b1912017-12-01 -> 2017-12-080002.8382b1912017-12-07 -> 2017-12-110002.8383b1922017-12-01 -> 2017-12-281285.1301557.050384b1922017-12-20 -> 2017-12-250002.51385b1932017-12-14 -> 2017-12-250002.5386b1932017-12-08 -> 2017-12-200002.49387b1942017-12-11 -> 2017-12-280002.49388b1942017-12-01 -> 2017-12-300002.48389b1952017-12-01 -> 2017-12-240298400390b1952017-12-15 -> 2017-12-210002.18391b1962017-12-13 -> 2017-12-230002.18392b1962017-12-07 -> 2017-12-110002.17393b1972017-12-13 -> 2017-12-130002.17394b1972017-12-01 -> 2017-12-010002.17395b1982017-12-04 -> 2017-12-280001.96396b1982017-12-11 -> 2017-12-130001.96397b1992017-12-22 -> 2017-12-28001.920398b1992017-12-16 -> 2017-12-260001.88399b2002017-12-20 -> 2017-12-200001.88400b2002017-12-13 -> 2017-12-270001.87401b2012017-12-13 -> 2017-12-190001.87402b2012017-12-04 -> 2017-12-040001.86403b2022017-12-19 -> 2017-12-300001.57404b2022017-12-23 -> 2017-12-310001.57405b2032017-12-23 -> 2017-12-290001.57406b2032017-12-02 -> 2017-12-310001.56407b2042017-12-15 -> 2017-12-150001.56408b2042017-12-03 -> 2017-12-260001.56409b2052017-12-11 -> 2017-12-220001.56410b2052017-12-26 -> 2017-12-29003550.80411b2062017-12-29 -> 2017-12-30001.370412b2062017-12-27 -> 2017-12-280001.25413b2072017-12-11 -> 2017-12-190001.24414b2072017-12-04 -> 2017-12-300001.24415b2082017-12-11 -> 2017-12-110001.24416b2082017-12-13 -> 2017-12-130001.24417b2092017-12-04 -> 2017-12-130001.24418b2092017-12-04 -> 2017-12-312505.15385.44723.580419b2102017-12-01 -> 2017-12-312235.2419.452263.120420b2102017-12-01 -> 2017-12-180001421b2112017-12-15 -> 2017-12-290000.99422b2112017-12-06 -> 2017-12-280000.99423b2122017-12-13 -> 2017-12-130000.98424b2122017-12-23 -> 2017-12-260000.94425b2132017-12-18 -> 2017-12-260000.94426b2132017-12-28 -> 2017-12-300000.94427b2142017-12-21 -> 2017-12-210000.94428b2142017-12-28 -> 2017-12-280000.94429b2152017-12-14 -> 2017-12-140000.93430b2152017-12-06 -> 2017-12-080000.93431b2162017-12-22 -> 2017-12-28000.830432b2162017-12-01 -> 2017-12-030000.77433b2172017-12-04 -> 2017-12-070000.77434b2172017-12-22 -> 2017-12-28000.650435b2182017-12-23 -> 2017-12-230000.63436b2182017-12-23 -> 2017-12-270000.63437b2192017-12-26 -> 2017-12-280000.63438b2192017-12-21 -> 2017-12-210000.63439b2202017-12-01 -> 2017-12-260000.62440b2202017-12-12 -> 2017-12-180000.62441b2212017-12-15 -> 2017-12-150000.62442b2212017-12-04 -> 2017-12-190000.62443b2222017-12-01 -> 2017-12-210000.62444b2222017-12-04 -> 2017-12-040000.62445b2232017-12-04 -> 2017-12-040000.62446b2232017-12-01 -> 2017-12-126208.44000447b2242017-12-01 -> 2017-12-31037.676815.380448b2242017-12-30 -> 2017-12-300000.31449b2252017-12-23 -> 2017-12-290000.31450b2252017-12-29 -> 2017-12-290000.31451b2262017-12-28 -> 2017-12-300000.31452b2262017-12-05 -> 2017-12-300000.31453b2272017-12-17 -> 2017-12-170000.31454b2272017-12-19 -> 2017-12-190000.31455b2282017-12-15 -> 2017-12-170000.31456b2282017-12-14 -> 2017-12-140000.31457b2292017-12-14 -> 2017-12-140000.31458b2292017-12-05 -> 2017-12-090000.31459b2302017-12-05 -> 2017-12-050000.31460b2302017-12-11 -> 2017-12-110000.31461b2312017-12-06 -> 2017-12-120000.31462b2312017-12-14 -> 2017-12-140000.31463b2322017-12-09 -> 2017-12-090000.31464b2322017-12-13 -> 2017-12-130000.31465b2332017-12-03 -> 2017-12-030000.31466b2332017-12-22 -> 2017-12-28000.290467b2342017-12-22 -> 2017-12-22000.280468b2342017-12-19 -> 2017-12-28000.260469b2352017-12-01 -> 2017-12-210249.4410169.30470b2352017-12-28 -> 2017-12-28000.040 Spoiler (Highlight to read) I want help with Microsoft excel average function. Please help me with following conditions in excel.Data is attached below.1What is the average total USD rev/parent?2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10 Data All rev in USD Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D1b12017-12-01 -> 2017-12-0100.19002b12017-12-18 -> 2017-12-18000.3103b12017-12-07 -> 2017-12-07000.4604b22017-12-24 -> 2017-12-25001.0705b32017-12-06 -> 2017-12-20001.1806b32017-12-24 -> 2017-12-29001.4701b12017-12-01 -> 2017-12-01002.1802b12017-12-01 -> 2017-12-01002.6903b12017-12-26 -> 2017-12-30002.9704b22017-12-01 -> 2017-12-01002.9905b32017-12-19 -> 2017-12-30004.2706b32017-12-21 -> 2017-12-22005.0107b72017-12-29 -> 2017-12-30006.8201b12017-12-01 -> 2017-12-02006.7901b12017-12-01 -> 2017-12-23008.65012b82017-12-16 -> 2017-12-17008.91017b92017-12-18 -> 2017-12-3109.720018b92017-12-01 -> 2017-12-01010.520019b102017-12-01 -> 2017-12-030011.26020b102017-12-08 -> 2017-12-31011.360021b112017-12-24 -> 2017-12-270012.93022b112017-12-07 -> 2017-12-090013.61023b22017-12-01 -> 2017-12-040013.99024b22017-12-22 -> 2017-12-220014.41025b132017-12-17 -> 2017-12-210015.49026b132017-12-13 -> 2017-12-260015.58027b142017-12-01 -> 2017-12-300015.59028b142017-12-01 -> 2017-12-140015.67029b32017-12-30 -> 2017-12-3116.1300030b32017-12-01 -> 2017-12-070016.09031b162017-12-07 -> 2017-12-07019.070032b162017-12-01 -> 2017-12-030019.67033b172017-12-04 -> 2017-12-26020.980034b172017-12-06 -> 2017-12-1021.4200035b42017-12-02 -> 2017-12-0508.6713.43036b42017-12-20 -> 2017-12-230022.66037b192017-12-12 -> 2017-12-190022.59038b192017-12-21 -> 2017-12-300021.551.8839b202017-12-28 -> 2017-12-3023.4900040b202017-12-05 -> 2017-12-120023.31041b212017-12-28 -> 2017-12-310024.07042b212017-12-07 -> 2017-12-160021.283.1243b222017-12-01 -> 2017-12-020024.79044b62017-12-21 -> 2017-12-31025.070045b72017-12-01 -> 2017-12-050024.83046b232017-12-07 -> 2017-12-2200620.04047b242017-12-04 -> 2017-12-05024.820048b242017-12-15 -> 2017-12-190025.52049b252017-12-12 -> 2017-12-170025.58050b252017-12-01 -> 2017-12-030025.93051b262017-12-08 -> 2017-12-110026.13052b262017-12-13 -> 2017-12-170026.45053b272017-12-06 -> 2017-12-130026.4054b272017-12-16 -> 2017-12-160026.82055b282017-12-01 -> 2017-12-040026.78056b282017-12-11 -> 2017-12-13027.890057b292017-12-21 -> 2017-12-260028.96058b292017-12-01 -> 2017-12-300027.321.8859b302017-12-10 -> 2017-12-120029.77060b302017-12-03 -> 2017-12-090030.21061b312017-12-07 -> 2017-12-23455.2600062b312017-12-01 -> 2017-12-170031.02063b322017-12-21 -> 2017-12-280032.49064b322017-12-01 -> 2017-12-0532.900065b332017-12-01 -> 2017-12-030033.08066b332017-12-07 -> 2017-12-190034.12067b342017-12-04 -> 2017-12-300035.22068b342017-12-01 -> 2017-12-03035.30069b352017-12-01 -> 2017-12-150036.97070b352017-12-12 -> 2017-12-180037.68071b362017-12-08 -> 2017-12-120038.29072b362017-12-16 -> 2017-12-19039.70073b372017-12-21 -> 2017-12-300041.7074b372017-12-01 -> 2017-12-300041.51075b382017-12-01 -> 2017-12-090046.48076b382017-12-27 -> 2017-12-290047.58077b392017-12-04 -> 2017-12-280034.9213.1678b392017-12-01 -> 2017-12-2002.5325.4120.8679b402017-12-01 -> 2017-12-040050.25080b402017-12-13 -> 2017-12-160050.56081b412017-12-01 -> 2017-12-040051.46082b412017-12-15 -> 2017-12-180053.82083b422017-12-07 -> 2017-12-180053.75084b422017-12-01 -> 2017-12-2303.5150.67085b432017-12-05 -> 2017-12-200048.355.9186b432017-12-20 -> 2017-12-300054.79087b442017-12-01 -> 2017-12-050054.66088b442017-12-01 -> 2017-12-090055.91089b452017-12-07 -> 2017-12-080056.03090b452017-12-01 -> 2017-12-070056.24091b462017-12-05 -> 2017-12-100056.671.5592b462017-12-20 -> 2017-12-2658.9500093b472017-12-01 -> 2017-12-20058.880094b472017-12-01 -> 2017-12-080059.19095b482017-12-28 -> 2017-12-310060.6096b482017-12-01 -> 2017-12-070060.39097b492017-12-01 -> 2017-12-150061.13098b492017-12-04 -> 2017-12-300062.87099b502017-12-04 -> 2017-12-060065.060100b502017-12-06 -> 2017-12-280065.520101b512017-12-01 -> 2017-12-150065.510102b512017-12-15 -> 2017-12-270066.780103b522017-12-01 -> 2017-12-180069.390104b522017-12-10 -> 2017-12-260070.560105b532017-12-01 -> 2017-12-120021.3549.68106b532017-12-01 -> 2017-12-090071.140107b542017-12-01 -> 2017-12-300072.490108b542017-12-01 -> 2017-12-300073.270109b552017-12-01 -> 2017-12-300073.530110b552017-12-01 -> 2017-12-220075.240111b562017-12-27 -> 2017-12-300075.770112b562017-12-03 -> 2017-12-150075.20113b572017-12-01 -> 2017-12-030077.820114b572017-12-01 -> 2017-12-070078.270115b582017-12-01 -> 2017-12-19078.500116b582017-12-01 -> 2017-12-190079.010117b592017-12-12 -> 2017-12-160079.330118b592017-12-26 -> 2017-12-300080.540119b602017-12-01 -> 2017-12-250081.060120b602017-12-21 -> 2017-12-300083.370121b612017-12-11 -> 2017-12-31084.8100.31122b612017-12-29 -> 2017-12-300086.130123b622017-12-04 -> 2017-12-170086.50124b622017-12-01 -> 2017-12-28087.700125b632017-12-01 -> 2017-12-31087.9300126b632017-12-01 -> 2017-12-050089.580127b642017-12-05 -> 2017-12-300091.980128b642017-12-22 -> 2017-12-300097.140129b652017-12-01 -> 2017-12-100098.350130b652017-12-01 -> 2017-12-050098.780131b662017-12-21 -> 2017-12-3100101.050132b662017-12-14 -> 2017-12-16000204.03133b672017-12-04 -> 2017-12-130096.245.28134b672017-12-28 -> 2017-12-3174.84029.570135b682017-12-07 -> 2017-12-200060.5344.7136b682017-12-01 -> 2017-12-2700107.930137b692017-12-01 -> 2017-12-2500110.990138b692017-12-26 -> 2017-12-3000112.180139b702017-12-09 -> 2017-12-1900113.50140b702017-12-01 -> 2017-12-3000116.890141b712017-12-07 -> 2017-12-31024.8391.921.87142b712017-12-01 -> 2017-12-1600119.310143b722017-12-11 -> 2017-12-3000120.410144b722017-12-01 -> 2017-12-1100121.480145b732017-12-01 -> 2017-12-3001.83121.440146b732017-12-11 -> 2017-12-280100.61028.38147b742017-12-01 -> 2017-12-31046.5683.410148b742017-12-20 -> 2017-12-3000132.120149b752017-12-01 -> 2017-12-2300132.280150b752017-12-08 -> 2017-12-3005.41121.310.29151b762017-12-01 -> 2017-12-1700137.460152b762017-12-20 -> 2017-12-3000139.820153b772017-12-01 -> 2017-12-0900138.770154b772017-12-30 -> 2017-12-31070.5772.230155b782017-12-01 -> 2017-12-1200143.870156b782017-12-05 -> 2017-12-2400145.860157b792017-12-12 -> 2017-12-3000146.530.31158b792017-12-01 -> 2017-12-1100146.980159b802017-12-17 -> 2017-12-3000156.590160b802017-12-02 -> 2017-12-30049.72107.230161b812017-12-01 -> 2017-12-2500160.80.31162b812017-12-01 -> 2017-12-3000161.510163b822017-12-02 -> 2017-12-1304.84157.720164b822017-12-29 -> 2017-12-3008.29156.160165b832017-12-01 -> 2017-12-1900164.60166b832017-12-15 -> 2017-12-2900167.461.87167b842017-12-01 -> 2017-12-3000169.980168b842017-12-21 -> 2017-12-2900172.240169b852017-12-01 -> 2017-12-11170.76000170b852017-12-01 -> 2017-12-21139.34038.460171b862017-12-01 -> 2017-12-2500177.510172b862017-12-10 -> 2017-12-1900179.610173b872017-12-19 -> 2017-12-3103.5178.50174b872017-12-27 -> 2017-12-30097.2590.620175b882017-12-01 -> 2017-12-3100187.10176b882017-12-01 -> 2017-12-310192.9600177b892017-12-01 -> 2017-12-3100179.8913.08178b892017-12-04 -> 2017-12-070192.4500179b902017-12-01 -> 2017-12-1500192.590180b902017-12-01 -> 2017-12-2900200.830181b912017-12-01 -> 2017-12-2700210.430182b912017-12-13 -> 2017-12-3000212.940183b922017-12-15 -> 2017-12-2500214.480184b922017-12-01 -> 2017-12-080065.89152.68185b932017-12-18 -> 2017-12-3000231.980186b932017-12-06 -> 2017-12-2989.710142.310187b942017-12-11 -> 2017-12-2900236.690188b942017-12-01 -> 2017-12-1100238.180189b952017-12-15 -> 2017-12-2700243.220190b952017-12-01 -> 2017-12-3000243.020191b962017-12-01 -> 2017-12-3100245.750192b962017-12-01 -> 2017-12-18246.13000193b972017-12-12 -> 2017-12-3000248.850194b972017-12-01 -> 2017-12-070252.2100195b982017-12-16 -> 2017-12-3000264.760196b982017-12-01 -> 2017-12-2300266.30197b992017-12-01 -> 2017-12-2900269.460198b992017-12-01 -> 2017-12-1800270.020199b1002017-12-01 -> 2017-12-30095.01177.660200b1002017-12-15 -> 2017-12-2100271.291.88201b1012017-12-01 -> 2017-12-2000277.780202b1012017-12-01 -> 2017-12-2200279.470203b1022017-12-20 -> 2017-12-2500075.18204b1022017-12-01 -> 2017-12-300127.97153.830205b1032017-12-01 -> 2017-12-1100282.80206b1032017-12-06 -> 2017-12-2300285.460207b1042017-12-10 -> 2017-12-3000291.490208b1042017-12-21 -> 2017-12-2700285.279.19209b1052017-12-13 -> 2017-12-3000302.520210b1052017-12-01 -> 2017-12-1700305.730211b1062017-12-23 -> 2017-12-300052.3914.76212b1062017-12-23 -> 2017-12-2701.75310.110213b1072017-12-18 -> 2017-12-2700311.40214b1072017-12-18 -> 2017-12-2700311.320215b1082017-12-22 -> 2017-12-280065.130216b1082017-12-11 -> 2017-12-2700310.360217b1092017-12-05 -> 2017-12-2700064.13218b1092017-12-13 -> 2017-12-2700310.330219b1102017-12-22 -> 2017-12-290062.340220b1102017-12-07 -> 2017-12-2700310.010221b1102017-12-12 -> 2017-12-2508.27301.720222b1102017-12-19 -> 2017-12-2900312.990223b1102017-12-13 -> 2017-12-3000312.480224b1102017-12-07 -> 2017-12-19010.44300.810225b1102017-12-11 -> 2017-12-2900312.250226b1102017-12-01 -> 2017-12-2200290.7528.19227b1102017-12-05 -> 2017-12-2800057.98228b1102017-12-01 -> 2017-12-3000328.670229b1102017-12-01 -> 2017-12-2900331.340.31230b1152017-12-01 -> 2017-12-13330.83000231b1162017-12-01 -> 2017-12-1700334.370232b1162017-12-05 -> 2017-12-3000339.490233b1172017-12-01 -> 2017-12-2100341.890234b1172017-12-01 -> 2017-12-31342.5000235b1182017-12-01 -> 2017-12-1500349.60236b1182017-12-01 -> 2017-12-2600350.660237b1192017-12-01 -> 2017-12-1800355.260238b1192017-12-22 -> 2017-12-290051.190239b1202017-12-01 -> 2017-12-3100359.320240b1202017-12-01 -> 2017-12-3100360.110.31241b1212017-12-01 -> 2017-12-23362.68000242b1212017-12-01 -> 2017-12-110373.2100243b1222017-12-06 -> 2017-12-170379.2800244b1222017-12-07 -> 2017-12-090047.310245b1232017-12-15 -> 2017-12-2700384.190246b1232017-12-01 -> 2017-12-310383.2700247b1242017-12-01 -> 2017-12-310216169.810248b1242017-12-07 -> 2017-12-2900041.3249b1252017-12-22 -> 2017-12-280039.740250b1252017-12-01 -> 2017-12-160386.1100251b1262017-12-22 -> 2017-12-270039.560252b1262017-12-20 -> 2017-12-2600389.360253b1272017-12-01 -> 2017-12-270172.79240.490254b1272017-12-01 -> 2017-12-31302.8815.6499.260255b1282017-12-22 -> 2017-12-290036.420256b1282017-12-22 -> 2017-12-300035.990257b1292017-12-01 -> 2017-12-270418.2400258b1292017-12-22 -> 2017-12-3100422.780259b1302017-12-01 -> 2017-12-2700420.820260b1302017-12-01 -> 2017-12-140193.11115.78119.33261b1312017-12-01 -> 2017-12-3000430.70262b1312017-12-01 -> 2017-12-2900451.880263b1322017-12-01 -> 2017-12-1600451.480264b1322017-12-01 -> 2017-12-28088.88374.380265b1332017-12-01 -> 2017-12-150462.4600266b1332017-12-01 -> 2017-12-2500463.910267b1342017-12-14 -> 2017-12-1900028.99268b1342017-12-24 -> 2017-12-2700470.190269b1352017-12-12 -> 2017-12-3100469.010270b1352017-12-05 -> 2017-12-2996.05336.9334.970271b1362017-12-06 -> 2017-12-2600026.8272b1362017-12-05 -> 2017-12-2800468.290273b1372017-12-07 -> 2017-12-27034.98433.830274b1372017-12-09 -> 2017-12-31386.84096.270275b1382017-12-01 -> 2017-12-3000485.570276b1382017-12-19 -> 2017-12-3000026277b1392017-12-01 -> 2017-12-2900511.510278b1392017-12-01 -> 2017-12-300105.97408.640.99279b1402017-12-14 -> 2017-12-280509.5233.470280b1402017-12-01 -> 2017-12-3000539.139.69281b1412017-12-01 -> 2017-12-290264.29367.120282b1412017-12-16 -> 2017-12-3103.14685.760283b1422017-12-15 -> 2017-12-2900699.810284b1422017-12-01 -> 2017-12-31046.53694.210285b1432017-12-05 -> 2017-12-3100743.390286b1432017-12-01 -> 2017-12-3000743.580287b1442017-12-01 -> 2017-12-230743.7900288b1442017-12-01 -> 2017-12-240399.4369.640289b1452017-12-01 -> 2017-12-2100023.31290b1452017-12-01 -> 2017-12-3000780.930291b1462017-12-01 -> 2017-12-3000787.070292b1462017-12-19 -> 2017-12-270789.7600293b1472017-12-05 -> 2017-12-2200791.070294b1472017-12-28 -> 2017-12-2900815.290295b1482017-12-22 -> 2017-12-300020.790296b1482017-12-01 -> 2017-12-3000020.19297b1492017-12-01 -> 2017-12-2600020.03298b1492017-12-01 -> 2017-12-270768.4289.310299b1502017-12-01 -> 2017-12-300772.85126.210300b1502017-12-22 -> 2017-12-300018.580301b1512017-12-09 -> 2017-12-2100018.33302b1512017-12-29 -> 2017-12-300017.540303b1522017-12-22 -> 2017-12-300016.280304b1522017-12-01 -> 2017-12-3000912.630305b1532017-12-12 -> 2017-12-27389.43264.39281.80306b1532017-12-01 -> 2017-12-2900951.010307b1542017-12-01 -> 2017-12-30001013.890308b1542017-12-01 -> 2017-12-27001012.948.8309b1552017-12-06 -> 2017-12-3000015.54310b1552017-12-01 -> 2017-12-2800871.33164.55311b1562017-12-01 -> 2017-12-230101.15881.6862.08312b1562017-12-01 -> 2017-12-3100014.41313b1572017-12-12 -> 2017-12-2801171.3800314b1572017-12-26 -> 2017-12-290013.970315b1582017-12-01 -> 2017-12-30001170.80316b1582017-12-28 -> 2017-12-3000013.46317b1592017-12-04 -> 2017-12-2100013.37318b1592017-12-22 -> 2017-12-280013.170319b1602017-12-09 -> 2017-12-1701168.2600320b1602017-12-11 -> 2017-12-1200012.74321b1612017-12-01 -> 2017-12-2800011.88322b1612017-12-08 -> 2017-12-2700011.54323b1622017-12-22 -> 2017-12-270011.410324b1622017-12-01 -> 2017-12-27001131.6951.23325b1632017-12-01 -> 2017-12-30001356.930326b1632017-12-11 -> 2017-12-2800010.93327b1642017-12-01 -> 2017-12-2501472.2900328b1642017-12-14 -> 2017-12-1400010.26329b1652017-12-01 -> 2017-12-23001506.30330b1652017-12-29 -> 2017-12-300009.72331b1662017-12-01 -> 2017-12-30001561.10332b1662017-12-22 -> 2017-12-29008.860333b1672017-12-02 -> 2017-12-240875.59686.30334b1672017-12-28 -> 2017-12-28008.550335b1682017-12-25 -> 2017-12-280008.15336b1682017-12-02 -> 2017-12-110008.07337b1692017-12-06 -> 2017-12-220007.78338b1692017-12-12 -> 2017-12-300007.78339b1702017-12-19 -> 2017-12-260007.51340b1702017-12-18 -> 2017-12-280007.19341b1712017-12-06 -> 2017-12-180006.89342b1712017-12-19 -> 2017-12-31022.161566.320343b1722017-12-01 -> 2017-12-2901268.35391.210344b1722017-12-01 -> 2017-12-290006.54345b1732017-12-27 -> 2017-12-270005.92346b1732017-12-22 -> 2017-12-30005.840347b1742017-12-22 -> 2017-12-23005.780348b1742017-12-04 -> 2017-12-310005.61349b1752017-12-23 -> 2017-12-240005.33350b1752017-12-21 -> 2017-12-220005.32351b1762017-12-12 -> 2017-12-210005.31352b1762017-12-01 -> 2017-12-290625.61363.140353b1772017-12-01 -> 2017-12-300005354b1772017-12-01 -> 2017-12-310004.89355b1782017-12-11 -> 2017-12-290004.67356b1782017-12-04 -> 2017-12-210004.66357b1792017-12-07 -> 2017-12-110004.35358b1792017-12-07 -> 2017-12-140004.35359b1802017-12-04 -> 2017-12-070004.35360b1802017-12-01 -> 2017-12-030004.34361b1812017-12-01 -> 2017-12-31002071.820362b1812017-12-30 -> 2017-12-300004.08363b1822017-12-22 -> 2017-12-270004.07364b1822017-12-06 -> 2017-12-240004.06365b1832017-12-05 -> 2017-12-280004.05366b1832017-12-27 -> 2017-12-30003.890367b1842017-12-22 -> 2017-12-270003.76368b1842017-12-01 -> 2017-12-010003.72369b1852017-12-07 -> 2017-12-310003.71370b1852017-12-30 -> 2017-12-300003.45371b1862017-12-22 -> 2017-12-270003.45372b1862017-12-21 -> 2017-12-210003.45373b1872017-12-13 -> 2017-12-290003.42374b1872017-12-29 -> 2017-12-300003.13375b1882017-12-19 -> 2017-12-190003.12376b1882017-12-13 -> 2017-12-240003.12377b1892017-12-14 -> 2017-12-260003.11378b1892017-12-01 -> 2017-12-2602103.3900379b1902017-12-21 -> 2017-12-30019.332349.750380b1902017-12-01 -> 2017-12-310002.81381b1912017-12-01 -> 2017-12-080002.8382b1912017-12-07 -> 2017-12-110002.8383b1922017-12-01 -> 2017-12-281285.1301557.050384b1922017-12-20 -> 2017-12-250002.51385b1932017-12-14 -> 2017-12-250002.5386b1932017-12-08 -> 2017-12-200002.49387b1942017-12-11 -> 2017-12-280002.49388b1942017-12-01 -> 2017-12-300002.48389b1952017-12-01 -> 2017-12-240298400390b1952017-12-15 -> 2017-12-210002.18391b1962017-12-13 -> 2017-12-230002.18392b1962017-12-07 -> 2017-12-110002.17393b1972017-12-13 -> 2017-12-130002.17394b1972017-12-01 -> 2017-12-010002.17395b1982017-12-04 -> 2017-12-280001.96396b1982017-12-11 -> 2017-12-130001.96397b1992017-12-22 -> 2017-12-28001.920398b1992017-12-16 -> 2017-12-260001.88399b2002017-12-20 -> 2017-12-200001.88400b2002017-12-13 -> 2017-12-270001.87401b2012017-12-13 -> 2017-12-190001.87402b2012017-12-04 -> 2017-12-040001.86403b2022017-12-19 -> 2017-12-300001.57404b2022017-12-23 -> 2017-12-310001.57405b2032017-12-23 -> 2017-12-290001.57406b2032017-12-02 -> 2017-12-310001.56407b2042017-12-15 -> 2017-12-150001.56408b2042017-12-03 -> 2017-12-260001.56409b2052017-12-11 -> 2017-12-220001.56410b2052017-12-26 -> 2017-12-29003550.80411b2062017-12-29 -> 2017-12-30001.370412b2062017-12-27 -> 2017-12-280001.25413b2072017-12-11 -> 2017-12-190001.24414b2072017-12-04 -> 2017-12-300001.24415b2082017-12-11 -> 2017-12-110001.24416b2082017-12-13 -> 2017-12-130001.24417b2092017-12-04 -> 2017-12-130001.24418b2092017-12-04 -> 2017-12-312505.15385.44723.580419b2102017-12-01 -> 2017-12-312235.2419.452263.120420b2102017-12-01 -> 2017-12-180001421b2112017-12-15 -> 2017-12-290000.99422b2112017-12-06 -> 2017-12-280000.99423b2122017-12-13 -> 2017-12-130000.98424b2122017-12-23 -> 2017-12-260000.94425b2132017-12-18 -> 2017-12-260000.94426b2132017-12-28 -> 2017-12-300000.94427b2142017-12-21 -> 2017-12-210000.94428b2142017-12-28 -> 2017-12-280000.94429b2152017-12-14 -> 2017-12-140000.93430b2152017-12-06 -> 2017-12-080000.93431b2162017-12-22 -> 2017-12-28000.830432b2162017-12-01 -> 2017-12-030000.77433b2172017-12-04 -> 2017-12-070000.77434b2172017-12-22 -> 2017-12-28000.650435b2182017-12-23 -> 2017-12-230000.63436b2182017-12-23 -> 2017-12-270000.63437b2192017-12-26 -> 2017-12-280000.63438b2192017-12-21 -> 2017-12-210000.63439b2202017-12-01 -> 2017-12-260000.62440b2202017-12-12 -> 2017-12-180000.62441b2212017-12-15 -> 2017-12-150000.62442b2212017-12-04 -> 2017-12-190000.62443b2222017-12-01 -> 2017-12-210000.62444b2222017-12-04 -> 2017-12-040000.62445b2232017-12-04 -> 2017-12-040000.62446b2232017-12-01 -> 2017-12-126208.44000447b2242017-12-01 -> 2017-12-31037.676815.380448b2242017-12-30 -> 2017-12-300000.31449b2252017-12-23 -> 2017-12-290000.31450b2252017-12-29 -> 2017-12-290000.31451b2262017-12-28 -> 2017-12-300000.31452b2262017-12-05 -> 2017-12-300000.31453b2272017-12-17 -> 2017-12-170000.31454b2272017-12-19 -> 2017-12-190000.31455b2282017-12-15 -> 2017-12-170000.31456b2282017-12-14 -> 2017-12-140000.31457b2292017-12-14 -> 2017-12-140000.31458b2292017-12-05 -> 2017-12-090000.31459b2302017-12-05 -> 2017-12-050000.31460b2302017-12-11 -> 2017-12-110000.31461b2312017-12-06 -> 2017-12-120000.31462b2312017-12-14 -> 2017-12-140000.31463b2322017-12-09 -> 2017-12-090000.31464b2322017-12-13 -> 2017-12-130000.31465b2332017-12-03 -> 2017-12-030000.31466b2332017-12-22 -> 2017-12-28000.290467b2342017-12-22 -> 2017-12-22000.280468b2342017-12-19 -> 2017-12-28000.260469b2352017-12-01 -> 2017-12-210249.4410169.30470b2352017-12-28 -> 2017-12-28000.040

deokars43 AVERAGE functionThis link describes the formula syntax and usage of the AVERAGE function in Microsoft Excel. How To Calculate Averages in Excel (2 Methods and Examples)...some more informations and exambles. Excel Function Bible for Excelexamble files from the upper link. Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk. Hope I could help you with these information / links. NikolinoDEI know I don't know anything (Socrates)

deokars43

Copper Contributor

Oct 29, 2022

Microsoft excel average function.

Spoiler

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1	What is the average total USD rev/parent?
2	What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3	What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4	How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

Data

All rev in USD

Child Id

Parent Company ID

Date Range

Rev from Product A

Rev from Product B

Rev from Product C

Rev from Product D

2017-12-01 -> 2017-12-01

0.19

2017-12-18 -> 2017-12-18

0.31

2017-12-07 -> 2017-12-07

0.46

2017-12-24 -> 2017-12-25

1.07

2017-12-06 -> 2017-12-20

1.18

2017-12-24 -> 2017-12-29

1.47

2017-12-01 -> 2017-12-01

2.18

2017-12-01 -> 2017-12-01

2.69

2017-12-26 -> 2017-12-30

2.97

2017-12-01 -> 2017-12-01

2.99

2017-12-19 -> 2017-12-30

4.27

2017-12-21 -> 2017-12-22

5.01

2017-12-29 -> 2017-12-30

6.82

2017-12-01 -> 2017-12-02

6.79

2017-12-01 -> 2017-12-23

8.65

2017-12-16 -> 2017-12-17

8.91

2017-12-18 -> 2017-12-31

9.72

2017-12-01 -> 2017-12-01

10.52

b10

2017-12-01 -> 2017-12-03

11.26

b10

2017-12-08 -> 2017-12-31

11.36

b11

2017-12-24 -> 2017-12-27

12.93

b11

2017-12-07 -> 2017-12-09

13.61

2017-12-01 -> 2017-12-04

13.99

2017-12-22 -> 2017-12-22

14.41

b13

2017-12-17 -> 2017-12-21

15.49

b13

2017-12-13 -> 2017-12-26

15.58

b14

2017-12-01 -> 2017-12-30

15.59

b14

2017-12-01 -> 2017-12-14

15.67

2017-12-30 -> 2017-12-31

16.13

2017-12-01 -> 2017-12-07

16.09

b16

2017-12-07 -> 2017-12-07

19.07

b16

2017-12-01 -> 2017-12-03

19.67

b17

2017-12-04 -> 2017-12-26

20.98

b17

2017-12-06 -> 2017-12-10

21.42

2017-12-02 -> 2017-12-05

8.67

13.43

2017-12-20 -> 2017-12-23

22.66

b19

2017-12-12 -> 2017-12-19

22.59

b19

2017-12-21 -> 2017-12-30

21.55

1.88

b20

2017-12-28 -> 2017-12-30

23.49

b20

2017-12-05 -> 2017-12-12

23.31

b21

2017-12-28 -> 2017-12-31

24.07

b21

2017-12-07 -> 2017-12-16

21.28

3.12

b22

2017-12-01 -> 2017-12-02

24.79

2017-12-21 -> 2017-12-31

25.07

2017-12-01 -> 2017-12-05

24.83

b23

2017-12-07 -> 2017-12-22

620.04

b24

2017-12-04 -> 2017-12-05

24.82

b24

2017-12-15 -> 2017-12-19

25.52

b25

2017-12-12 -> 2017-12-17

25.58

b25

2017-12-01 -> 2017-12-03

25.93

b26

2017-12-08 -> 2017-12-11

26.13

b26

2017-12-13 -> 2017-12-17

26.45

b27

2017-12-06 -> 2017-12-13

26.4

b27

2017-12-16 -> 2017-12-16

26.82

b28

2017-12-01 -> 2017-12-04

26.78

b28

2017-12-11 -> 2017-12-13

27.89

b29

2017-12-21 -> 2017-12-26

28.96

b29

2017-12-01 -> 2017-12-30

27.32

1.88

b30

2017-12-10 -> 2017-12-12

29.77

b30

2017-12-03 -> 2017-12-09

30.21

b31

2017-12-07 -> 2017-12-23

455.26

b31

2017-12-01 -> 2017-12-17

31.02

b32

2017-12-21 -> 2017-12-28

32.49

b32

2017-12-01 -> 2017-12-05

32.9

b33

2017-12-01 -> 2017-12-03

33.08

b33

2017-12-07 -> 2017-12-19

34.12

b34

2017-12-04 -> 2017-12-30

35.22

b34

2017-12-01 -> 2017-12-03

35.3

b35

2017-12-01 -> 2017-12-15

36.97

b35

2017-12-12 -> 2017-12-18

37.68

b36

2017-12-08 -> 2017-12-12

38.29

b36

2017-12-16 -> 2017-12-19

39.7

b37

2017-12-21 -> 2017-12-30

41.7

b37

2017-12-01 -> 2017-12-30

41.51

b38

2017-12-01 -> 2017-12-09

46.48

b38

2017-12-27 -> 2017-12-29

47.58

b39

2017-12-04 -> 2017-12-28

34.92

13.16

b39

2017-12-01 -> 2017-12-20

2.53

25.41

20.86

b40

2017-12-01 -> 2017-12-04

50.25

b40

2017-12-13 -> 2017-12-16

50.56

b41

2017-12-01 -> 2017-12-04

51.46

b41

2017-12-15 -> 2017-12-18

53.82

b42

2017-12-07 -> 2017-12-18

53.75

b42

2017-12-01 -> 2017-12-23

3.51

50.67

b43

2017-12-05 -> 2017-12-20

48.35

5.91

b43

2017-12-20 -> 2017-12-30

54.79

b44

2017-12-01 -> 2017-12-05

54.66

b44

2017-12-01 -> 2017-12-09

55.91

b45

2017-12-07 -> 2017-12-08

56.03

b45

2017-12-01 -> 2017-12-07

56.24

b46

2017-12-05 -> 2017-12-10

56.67

1.55

b46

2017-12-20 -> 2017-12-26

58.95

b47

2017-12-01 -> 2017-12-20

58.88

b47

2017-12-01 -> 2017-12-08

59.19

b48

2017-12-28 -> 2017-12-31

60.6

b48

2017-12-01 -> 2017-12-07

60.39

b49

2017-12-01 -> 2017-12-15

61.13

b49

2017-12-04 -> 2017-12-30

62.87

b50

2017-12-04 -> 2017-12-06

65.06

100

b50

2017-12-06 -> 2017-12-28

65.52

101

b51

2017-12-01 -> 2017-12-15

65.51

102

b51

2017-12-15 -> 2017-12-27

66.78

103

b52

2017-12-01 -> 2017-12-18

69.39

104

b52

2017-12-10 -> 2017-12-26

70.56

105

b53

2017-12-01 -> 2017-12-12

21.35

49.68

106

b53

2017-12-01 -> 2017-12-09

71.14

107

b54

2017-12-01 -> 2017-12-30

72.49

108

b54

2017-12-01 -> 2017-12-30

73.27

109

b55

2017-12-01 -> 2017-12-30

73.53

110

b55

2017-12-01 -> 2017-12-22

75.24

111

b56

2017-12-27 -> 2017-12-30

75.77

112

b56

2017-12-03 -> 2017-12-15

75.2

113

b57

2017-12-01 -> 2017-12-03

77.82

114

b57

2017-12-01 -> 2017-12-07

78.27

115

b58

2017-12-01 -> 2017-12-19

78.5

116

b58

2017-12-01 -> 2017-12-19

79.01

117

b59

2017-12-12 -> 2017-12-16

79.33

118

b59

2017-12-26 -> 2017-12-30

80.54

119

b60

2017-12-01 -> 2017-12-25

81.06

120

b60

2017-12-21 -> 2017-12-30

83.37

121

b61

2017-12-11 -> 2017-12-31

84.81

0.31

122

b61

2017-12-29 -> 2017-12-30

86.13

123

b62

2017-12-04 -> 2017-12-17

86.5

124

b62

2017-12-01 -> 2017-12-28

87.7

125

b63

2017-12-01 -> 2017-12-31

87.93

126

b63

2017-12-01 -> 2017-12-05

89.58

127

b64

2017-12-05 -> 2017-12-30

91.98

128

b64

2017-12-22 -> 2017-12-30

97.14

129

b65

2017-12-01 -> 2017-12-10

98.35

130

b65

2017-12-01 -> 2017-12-05

98.78

131

b66

2017-12-21 -> 2017-12-31

101.05

132

b66

2017-12-14 -> 2017-12-16

204.03

133

b67

2017-12-04 -> 2017-12-13

96.24

5.28

134

b67

2017-12-28 -> 2017-12-31

74.84

29.57

135

b68

2017-12-07 -> 2017-12-20

60.53

44.7

136

b68

2017-12-01 -> 2017-12-27

107.93

137

b69

2017-12-01 -> 2017-12-25

110.99

138

b69

2017-12-26 -> 2017-12-30

112.18

139

b70

2017-12-09 -> 2017-12-19

113.5

140

b70

2017-12-01 -> 2017-12-30

116.89

141

b71

2017-12-07 -> 2017-12-31

24.83

91.92

1.87

142

b71

2017-12-01 -> 2017-12-16

119.31

143

b72

2017-12-11 -> 2017-12-30

120.41

144

b72

2017-12-01 -> 2017-12-11

121.48

145

b73

2017-12-01 -> 2017-12-30

1.83

121.44

146

b73

2017-12-11 -> 2017-12-28

100.61

28.38

147

b74

2017-12-01 -> 2017-12-31

46.56

83.41

148

b74

2017-12-20 -> 2017-12-30

132.12

149

b75

2017-12-01 -> 2017-12-23

132.28

150

b75

2017-12-08 -> 2017-12-30

5.41

121.3

10.29

151

b76

2017-12-01 -> 2017-12-17

137.46

152

b76

2017-12-20 -> 2017-12-30

139.82

153

b77

2017-12-01 -> 2017-12-09

138.77

154

b77

2017-12-30 -> 2017-12-31

70.57

72.23

155

b78

2017-12-01 -> 2017-12-12

143.87

156

b78

2017-12-05 -> 2017-12-24

145.86

157

b79

2017-12-12 -> 2017-12-30

146.53

0.31

158

b79

2017-12-01 -> 2017-12-11

146.98

159

b80

2017-12-17 -> 2017-12-30

156.59

160

b80

2017-12-02 -> 2017-12-30

49.72

107.23

161

b81

2017-12-01 -> 2017-12-25

160.8

0.31

162

b81

2017-12-01 -> 2017-12-30

161.51

163

b82

2017-12-02 -> 2017-12-13

4.84

157.72

164

b82

2017-12-29 -> 2017-12-30

8.29

156.16

165

b83

2017-12-01 -> 2017-12-19

164.6

166

b83

2017-12-15 -> 2017-12-29

167.46

1.87

167

b84

2017-12-01 -> 2017-12-30

169.98

168

b84

2017-12-21 -> 2017-12-29

172.24

169

b85

2017-12-01 -> 2017-12-11

170.76

170

b85

2017-12-01 -> 2017-12-21

139.34

38.46

171

b86

2017-12-01 -> 2017-12-25

177.51

172

b86

2017-12-10 -> 2017-12-19

179.61

173

b87

2017-12-19 -> 2017-12-31

3.5

178.5

174

b87

2017-12-27 -> 2017-12-30

97.25

90.62

175

b88

2017-12-01 -> 2017-12-31

187.1

176

b88

2017-12-01 -> 2017-12-31

192.96

177

b89

2017-12-01 -> 2017-12-31

179.89

13.08

178

b89

2017-12-04 -> 2017-12-07

192.45

179

b90

2017-12-01 -> 2017-12-15

192.59

180

b90

2017-12-01 -> 2017-12-29

200.83

181

b91

2017-12-01 -> 2017-12-27

210.43

182

b91

2017-12-13 -> 2017-12-30

212.94

183

b92

2017-12-15 -> 2017-12-25

214.48

184

b92

2017-12-01 -> 2017-12-08

65.89

152.68

185

b93

2017-12-18 -> 2017-12-30

231.98

186

b93

2017-12-06 -> 2017-12-29

89.71

142.31

187

b94

2017-12-11 -> 2017-12-29

236.69

188

b94

2017-12-01 -> 2017-12-11

238.18

189

b95

2017-12-15 -> 2017-12-27

243.22

190

b95

2017-12-01 -> 2017-12-30

243.02

191

b96

2017-12-01 -> 2017-12-31

245.75

192

b96

2017-12-01 -> 2017-12-18

246.13

193

b97

2017-12-12 -> 2017-12-30

248.85

194

b97

2017-12-01 -> 2017-12-07

252.21

195

b98

2017-12-16 -> 2017-12-30

264.76

196

b98

2017-12-01 -> 2017-12-23

266.3

197

b99

2017-12-01 -> 2017-12-29

269.46

198

b99

2017-12-01 -> 2017-12-18

270.02

199

b100

2017-12-01 -> 2017-12-30

95.01

177.66

200

b100

2017-12-15 -> 2017-12-21

271.29

1.88

201

b101

2017-12-01 -> 2017-12-20

277.78

202

b101

2017-12-01 -> 2017-12-22

279.47

203

b102

2017-12-20 -> 2017-12-25

75.18

204

b102

2017-12-01 -> 2017-12-30

127.97

153.83

205

b103

2017-12-01 -> 2017-12-11

282.8

206

b103

2017-12-06 -> 2017-12-23

285.46

207

b104

2017-12-10 -> 2017-12-30

291.49

208

b104

2017-12-21 -> 2017-12-27

285.27

9.19

209

b105

2017-12-13 -> 2017-12-30

302.52

210

b105

2017-12-01 -> 2017-12-17

305.73

211

b106

2017-12-23 -> 2017-12-30

52.39

14.76

212

b106

2017-12-23 -> 2017-12-27

1.75

310.11

213

b107

2017-12-18 -> 2017-12-27

311.4

214

b107

2017-12-18 -> 2017-12-27

311.32

215

b108

2017-12-22 -> 2017-12-28

65.13

216

b108

2017-12-11 -> 2017-12-27

310.36

217

b109

2017-12-05 -> 2017-12-27

64.13

218

b109

2017-12-13 -> 2017-12-27

310.33

219

b110

2017-12-22 -> 2017-12-29

62.34

220

b110

2017-12-07 -> 2017-12-27

310.01

221

b110

2017-12-12 -> 2017-12-25

8.27

301.72

222

b110

2017-12-19 -> 2017-12-29

312.99

223

b110

2017-12-13 -> 2017-12-30

312.48

224

b110

2017-12-07 -> 2017-12-19

10.44

300.81

225

b110

2017-12-11 -> 2017-12-29

312.25

226

b110

2017-12-01 -> 2017-12-22

290.75

28.19

227

b110

2017-12-05 -> 2017-12-28

57.98

228

b110

2017-12-01 -> 2017-12-30

328.67

229

b110

2017-12-01 -> 2017-12-29

331.34

0.31

230

b115

2017-12-01 -> 2017-12-13

330.83

231

b116

2017-12-01 -> 2017-12-17

334.37

232

b116

2017-12-05 -> 2017-12-30

339.49

233

b117

2017-12-01 -> 2017-12-21

341.89

234

b117

2017-12-01 -> 2017-12-31

342.5

235

b118

2017-12-01 -> 2017-12-15

349.6

236

b118

2017-12-01 -> 2017-12-26

350.66

237

b119

2017-12-01 -> 2017-12-18

355.26

238

b119

2017-12-22 -> 2017-12-29

51.19

239

b120

2017-12-01 -> 2017-12-31

359.32

240

b120

2017-12-01 -> 2017-12-31

360.11

0.31

241

b121

2017-12-01 -> 2017-12-23

362.68

242

b121

2017-12-01 -> 2017-12-11

373.21

243

b122

2017-12-06 -> 2017-12-17

379.28

244

b122

2017-12-07 -> 2017-12-09

47.31

245

b123

2017-12-15 -> 2017-12-27

384.19

246

b123

2017-12-01 -> 2017-12-31

383.27

247

b124

2017-12-01 -> 2017-12-31

216

169.81

248

b124

2017-12-07 -> 2017-12-29

41.3

249

b125

2017-12-22 -> 2017-12-28

39.74

250

b125

2017-12-01 -> 2017-12-16

386.11

251

b126

2017-12-22 -> 2017-12-27

39.56

252

b126

2017-12-20 -> 2017-12-26

389.36

253

b127

2017-12-01 -> 2017-12-27

172.79

240.49

254

b127

2017-12-01 -> 2017-12-31

302.88

15.64

99.26

255

b128

2017-12-22 -> 2017-12-29

36.42

256

b128

2017-12-22 -> 2017-12-30

35.99

257

b129

2017-12-01 -> 2017-12-27

418.24

258

b129

2017-12-22 -> 2017-12-31

422.78

259

b130

2017-12-01 -> 2017-12-27

420.82

260

b130

2017-12-01 -> 2017-12-14

193.11

115.78

119.33

261

b131

2017-12-01 -> 2017-12-30

430.7

262

b131

2017-12-01 -> 2017-12-29

451.88

263

b132

2017-12-01 -> 2017-12-16

451.48

264

b132

2017-12-01 -> 2017-12-28

88.88

374.38

265

b133

2017-12-01 -> 2017-12-15

462.46

266

b133

2017-12-01 -> 2017-12-25

463.91

267

b134

2017-12-14 -> 2017-12-19

28.99

268

b134

2017-12-24 -> 2017-12-27

470.19

269

b135

2017-12-12 -> 2017-12-31

469.01

270

b135

2017-12-05 -> 2017-12-29

96.05

336.93

34.97

271

b136

2017-12-06 -> 2017-12-26

26.8

272

b136

2017-12-05 -> 2017-12-28

468.29

273

b137

2017-12-07 -> 2017-12-27

34.98

433.83

274

b137

2017-12-09 -> 2017-12-31

386.84

96.27

275

b138

2017-12-01 -> 2017-12-30

485.57

276

b138

2017-12-19 -> 2017-12-30

277

b139

2017-12-01 -> 2017-12-29

511.51

278

b139

2017-12-01 -> 2017-12-30

105.97

408.64

0.99

279

b140

2017-12-14 -> 2017-12-28

509.52

33.47

280

b140

2017-12-01 -> 2017-12-30

539.13

9.69

281

b141

2017-12-01 -> 2017-12-29

264.29

367.12

282

b141

2017-12-16 -> 2017-12-31

3.14

685.76

283

b142

2017-12-15 -> 2017-12-29

699.81

284

b142

2017-12-01 -> 2017-12-31

46.53

694.21

285

b143

2017-12-05 -> 2017-12-31

743.39

286

b143

2017-12-01 -> 2017-12-30

743.58

287

b144

2017-12-01 -> 2017-12-23

743.79

288

b144

2017-12-01 -> 2017-12-24

399.4

369.64

289

b145

2017-12-01 -> 2017-12-21

23.31

290

b145

2017-12-01 -> 2017-12-30

780.93

291

b146

2017-12-01 -> 2017-12-30

787.07

292

b146

2017-12-19 -> 2017-12-27

789.76

293

b147

2017-12-05 -> 2017-12-22

791.07

294

b147

2017-12-28 -> 2017-12-29

815.29

295

b148

2017-12-22 -> 2017-12-30

20.79

296

b148

2017-12-01 -> 2017-12-30

20.19

297

b149

2017-12-01 -> 2017-12-26

20.03

298

b149

2017-12-01 -> 2017-12-27

768.42

89.31

299

b150

2017-12-01 -> 2017-12-30

772.85

126.21

300

b150

2017-12-22 -> 2017-12-30

18.58

301

b151

2017-12-09 -> 2017-12-21

18.33

302

b151

2017-12-29 -> 2017-12-30

17.54

303

b152

2017-12-22 -> 2017-12-30

16.28

304

b152

2017-12-01 -> 2017-12-30

912.63

305

b153

2017-12-12 -> 2017-12-27

389.43

264.39

281.8

306

b153

2017-12-01 -> 2017-12-29

951.01

307

b154

2017-12-01 -> 2017-12-30

1013.89

308

b154

2017-12-01 -> 2017-12-27

1012.94

8.8

309

b155

2017-12-06 -> 2017-12-30

15.54

310

b155

2017-12-01 -> 2017-12-28

871.33

164.55

311

b156

2017-12-01 -> 2017-12-23

101.15

881.68

62.08

312

b156

2017-12-01 -> 2017-12-31

14.41

313

b157

2017-12-12 -> 2017-12-28

1171.38

314

b157

2017-12-26 -> 2017-12-29

13.97

315

b158

2017-12-01 -> 2017-12-30

1170.8

316

b158

2017-12-28 -> 2017-12-30

13.46

317

b159

2017-12-04 -> 2017-12-21

13.37

318

b159

2017-12-22 -> 2017-12-28

13.17

319

b160

2017-12-09 -> 2017-12-17

1168.26

320

b160

2017-12-11 -> 2017-12-12

12.74

321

b161

2017-12-01 -> 2017-12-28

11.88

322

b161

2017-12-08 -> 2017-12-27

11.54

323

b162

2017-12-22 -> 2017-12-27

11.41

324

b162

2017-12-01 -> 2017-12-27

1131.69

51.23

325

b163

2017-12-01 -> 2017-12-30

1356.93

326

b163

2017-12-11 -> 2017-12-28

10.93

327

b164

2017-12-01 -> 2017-12-25

1472.29

328

b164

2017-12-14 -> 2017-12-14

10.26

329

b165

2017-12-01 -> 2017-12-23

1506.3

330

b165

2017-12-29 -> 2017-12-30

9.72

331

b166

2017-12-01 -> 2017-12-30

1561.1

332

b166

2017-12-22 -> 2017-12-29

8.86

333

b167

2017-12-02 -> 2017-12-24

875.59

686.3

334

b167

2017-12-28 -> 2017-12-28

8.55

335

b168

2017-12-25 -> 2017-12-28

8.15

336

b168

2017-12-02 -> 2017-12-11

8.07

337

b169

2017-12-06 -> 2017-12-22

7.78

338

b169

2017-12-12 -> 2017-12-30

7.78

339

b170

2017-12-19 -> 2017-12-26

7.51

340

b170

2017-12-18 -> 2017-12-28

7.19

341

b171

2017-12-06 -> 2017-12-18

6.89

342

b171

2017-12-19 -> 2017-12-31

22.16

1566.32

343

b172

2017-12-01 -> 2017-12-29

1268.35

391.21

344

b172

2017-12-01 -> 2017-12-29

6.54

345

b173

2017-12-27 -> 2017-12-27

5.92

346

b173

2017-12-22 -> 2017-12-30

5.84

347

b174

2017-12-22 -> 2017-12-23

5.78

348

b174

2017-12-04 -> 2017-12-31

5.61

349

b175

2017-12-23 -> 2017-12-24

5.33

350

b175

2017-12-21 -> 2017-12-22

5.32

351

b176

2017-12-12 -> 2017-12-21

5.31

352

b176

2017-12-01 -> 2017-12-29

625.6

1363.14

353

b177

2017-12-01 -> 2017-12-30

354

b177

2017-12-01 -> 2017-12-31

4.89

355

b178

2017-12-11 -> 2017-12-29

4.67

356

b178

2017-12-04 -> 2017-12-21

4.66

357

b179

2017-12-07 -> 2017-12-11

4.35

358

b179

2017-12-07 -> 2017-12-14

4.35

359

b180

2017-12-04 -> 2017-12-07

4.35

360

b180

2017-12-01 -> 2017-12-03

4.34

361

b181

2017-12-01 -> 2017-12-31

2071.82

362

b181

2017-12-30 -> 2017-12-30

4.08

363

b182

2017-12-22 -> 2017-12-27

4.07

364

b182

2017-12-06 -> 2017-12-24

4.06

365

b183

2017-12-05 -> 2017-12-28

4.05

366

b183

2017-12-27 -> 2017-12-30

3.89

367

b184

2017-12-22 -> 2017-12-27

3.76

368

b184

2017-12-01 -> 2017-12-01

3.72

369

b185

2017-12-07 -> 2017-12-31

3.71

370

b185

2017-12-30 -> 2017-12-30

3.45

371

b186

2017-12-22 -> 2017-12-27

3.45

372

b186

2017-12-21 -> 2017-12-21

3.45

373

b187

2017-12-13 -> 2017-12-29

3.42

374

b187

2017-12-29 -> 2017-12-30

3.13

375

b188

2017-12-19 -> 2017-12-19

3.12

376

b188

2017-12-13 -> 2017-12-24

3.12

377

b189

2017-12-14 -> 2017-12-26

3.11

378

b189

2017-12-01 -> 2017-12-26

2103.39

379

b190

2017-12-21 -> 2017-12-30

19.33

2349.75

380

b190

2017-12-01 -> 2017-12-31

2.81

381

b191

2017-12-01 -> 2017-12-08

2.8

382

b191

2017-12-07 -> 2017-12-11

2.8

383

b192

2017-12-01 -> 2017-12-28

1285.13

1557.05

384

b192

2017-12-20 -> 2017-12-25

2.51

385

b193

2017-12-14 -> 2017-12-25

2.5

386

b193

2017-12-08 -> 2017-12-20

2.49

387

b194

2017-12-11 -> 2017-12-28

2.49

388

b194

2017-12-01 -> 2017-12-30

2.48

389

b195

2017-12-01 -> 2017-12-24

2984

390

b195

2017-12-15 -> 2017-12-21

2.18

391

b196

2017-12-13 -> 2017-12-23

2.18

392

b196

2017-12-07 -> 2017-12-11

2.17

393

b197

2017-12-13 -> 2017-12-13

2.17

394

b197

2017-12-01 -> 2017-12-01

2.17

395

b198

2017-12-04 -> 2017-12-28

1.96

396

b198

2017-12-11 -> 2017-12-13

1.96

397

b199

2017-12-22 -> 2017-12-28

1.92

398

b199

2017-12-16 -> 2017-12-26

1.88

399

b200

2017-12-20 -> 2017-12-20

1.88

400

b200

2017-12-13 -> 2017-12-27

1.87

401

b201

2017-12-13 -> 2017-12-19

1.87

402

b201

2017-12-04 -> 2017-12-04

1.86

403

b202

2017-12-19 -> 2017-12-30

1.57

404

b202

2017-12-23 -> 2017-12-31

1.57

405

b203

2017-12-23 -> 2017-12-29

1.57

406

b203

2017-12-02 -> 2017-12-31

1.56

407

b204

2017-12-15 -> 2017-12-15

1.56

408

b204

2017-12-03 -> 2017-12-26

1.56

409

b205

2017-12-11 -> 2017-12-22

1.56

410

b205

2017-12-26 -> 2017-12-29

3550.8

411

b206

2017-12-29 -> 2017-12-30

1.37

412

b206

2017-12-27 -> 2017-12-28

1.25

413

b207

2017-12-11 -> 2017-12-19

1.24

414

b207

2017-12-04 -> 2017-12-30

1.24

415

b208

2017-12-11 -> 2017-12-11

1.24

416

b208

2017-12-13 -> 2017-12-13

1.24

417

b209

2017-12-04 -> 2017-12-13

1.24

418

b209

2017-12-04 -> 2017-12-31

2505.15

385.44

723.58

419

b210

2017-12-01 -> 2017-12-31

2235.2

419.45

2263.12

420

b210

2017-12-01 -> 2017-12-18

421

b211

2017-12-15 -> 2017-12-29

0.99

422

b211

2017-12-06 -> 2017-12-28

0.99

423

b212

2017-12-13 -> 2017-12-13

0.98

424

b212

2017-12-23 -> 2017-12-26

0.94

425

b213

2017-12-18 -> 2017-12-26

0.94

426

b213

2017-12-28 -> 2017-12-30

0.94

427

b214

2017-12-21 -> 2017-12-21

0.94

428

b214

2017-12-28 -> 2017-12-28

0.94

429

b215

2017-12-14 -> 2017-12-14

0.93

430

b215

2017-12-06 -> 2017-12-08

0.93

431

b216

2017-12-22 -> 2017-12-28

0.83

432

b216

2017-12-01 -> 2017-12-03

0.77

433

b217

2017-12-04 -> 2017-12-07

0.77

434

b217

2017-12-22 -> 2017-12-28

0.65

435

b218

2017-12-23 -> 2017-12-23

0.63

436

b218

2017-12-23 -> 2017-12-27

0.63

437

b219

2017-12-26 -> 2017-12-28

0.63

438

b219

2017-12-21 -> 2017-12-21

0.63

439

b220

2017-12-01 -> 2017-12-26

0.62

440

b220

2017-12-12 -> 2017-12-18

0.62

441

b221

2017-12-15 -> 2017-12-15

0.62

442

b221

2017-12-04 -> 2017-12-19

0.62

443

b222

2017-12-01 -> 2017-12-21

0.62

444

b222

2017-12-04 -> 2017-12-04

0.62

445

b223

2017-12-04 -> 2017-12-04

0.62

446

b223

2017-12-01 -> 2017-12-12

6208.44

447

b224

2017-12-01 -> 2017-12-31

37.67

6815.38

448

b224

2017-12-30 -> 2017-12-30

0.31

449

b225

2017-12-23 -> 2017-12-29

0.31

450

b225

2017-12-29 -> 2017-12-29

0.31

451

b226

2017-12-28 -> 2017-12-30

0.31

452

b226

2017-12-05 -> 2017-12-30

0.31

453

b227

2017-12-17 -> 2017-12-17

0.31

454

b227

2017-12-19 -> 2017-12-19

0.31

455

b228

2017-12-15 -> 2017-12-17

0.31

456

b228

2017-12-14 -> 2017-12-14

0.31

457

b229

2017-12-14 -> 2017-12-14

0.31

458

b229

2017-12-05 -> 2017-12-09

0.31

459

b230

2017-12-05 -> 2017-12-05

0.31

460

b230

2017-12-11 -> 2017-12-11

0.31

461

b231

2017-12-06 -> 2017-12-12

0.31

462

b231

2017-12-14 -> 2017-12-14

0.31

463

b232

2017-12-09 -> 2017-12-09

0.31

464

b232

2017-12-13 -> 2017-12-13

0.31

465

b233

2017-12-03 -> 2017-12-03

0.31

466

b233

2017-12-22 -> 2017-12-28

0.29

467

b234

2017-12-22 -> 2017-12-22

0.28

468

b234

2017-12-19 -> 2017-12-28

0.26

469

b235

2017-12-01 -> 2017-12-21

249.44

10169.3

470

b235

2017-12-28 -> 2017-12-28

0.04

Spoiler

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1	What is the average total USD rev/parent?
2	What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3	What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4	How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

Data

All rev in USD
Child Id	Parent Company ID	Date Range	Rev from Product A	Rev from Product B	Rev from Product C	Rev from Product D
1	b1	2017-12-01 -> 2017-12-01	0	0.19	0	0
2	b1	2017-12-18 -> 2017-12-18	0	0	0.31	0
3	b1	2017-12-07 -> 2017-12-07	0	0	0.46	0
4	b2	2017-12-24 -> 2017-12-25	0	0	1.07	0
5	b3	2017-12-06 -> 2017-12-20	0	0	1.18	0
6	b3	2017-12-24 -> 2017-12-29	0	0	1.47	0
1	b1	2017-12-01 -> 2017-12-01	0	0	2.18	0
2	b1	2017-12-01 -> 2017-12-01	0	0	2.69	0
3	b1	2017-12-26 -> 2017-12-30	0	0	2.97	0
4	b2	2017-12-01 -> 2017-12-01	0	0	2.99	0
5	b3	2017-12-19 -> 2017-12-30	0	0	4.27	0
6	b3	2017-12-21 -> 2017-12-22	0	0	5.01	0
7	b7	2017-12-29 -> 2017-12-30	0	0	6.82	0
1	b1	2017-12-01 -> 2017-12-02	0	0	6.79	0
1	b1	2017-12-01 -> 2017-12-23	0	0	8.65	0
12	b8	2017-12-16 -> 2017-12-17	0	0	8.91	0
17	b9	2017-12-18 -> 2017-12-31	0	9.72	0	0
18	b9	2017-12-01 -> 2017-12-01	0	10.52	0	0
19	b10	2017-12-01 -> 2017-12-03	0	0	11.26	0
20	b10	2017-12-08 -> 2017-12-31	0	11.36	0	0
21	b11	2017-12-24 -> 2017-12-27	0	0	12.93	0
22	b11	2017-12-07 -> 2017-12-09	0	0	13.61	0
23	b2	2017-12-01 -> 2017-12-04	0	0	13.99	0
24	b2	2017-12-22 -> 2017-12-22	0	0	14.41	0
25	b13	2017-12-17 -> 2017-12-21	0	0	15.49	0
26	b13	2017-12-13 -> 2017-12-26	0	0	15.58	0
27	b14	2017-12-01 -> 2017-12-30	0	0	15.59	0
28	b14	2017-12-01 -> 2017-12-14	0	0	15.67	0
29	b3	2017-12-30 -> 2017-12-31	16.13	0	0	0
30	b3	2017-12-01 -> 2017-12-07	0	0	16.09	0
31	b16	2017-12-07 -> 2017-12-07	0	19.07	0	0
32	b16	2017-12-01 -> 2017-12-03	0	0	19.67	0
33	b17	2017-12-04 -> 2017-12-26	0	20.98	0	0
34	b17	2017-12-06 -> 2017-12-10	21.42	0	0	0
35	b4	2017-12-02 -> 2017-12-05	0	8.67	13.43	0
36	b4	2017-12-20 -> 2017-12-23	0	0	22.66	0
37	b19	2017-12-12 -> 2017-12-19	0	0	22.59	0
38	b19	2017-12-21 -> 2017-12-30	0	0	21.55	1.88
39	b20	2017-12-28 -> 2017-12-30	23.49	0	0	0
40	b20	2017-12-05 -> 2017-12-12	0	0	23.31	0
41	b21	2017-12-28 -> 2017-12-31	0	0	24.07	0
42	b21	2017-12-07 -> 2017-12-16	0	0	21.28	3.12
43	b22	2017-12-01 -> 2017-12-02	0	0	24.79	0
44	b6	2017-12-21 -> 2017-12-31	0	25.07	0	0
45	b7	2017-12-01 -> 2017-12-05	0	0	24.83	0
46	b23	2017-12-07 -> 2017-12-22	0	0	620.04	0
47	b24	2017-12-04 -> 2017-12-05	0	24.82	0	0
48	b24	2017-12-15 -> 2017-12-19	0	0	25.52	0
49	b25	2017-12-12 -> 2017-12-17	0	0	25.58	0
50	b25	2017-12-01 -> 2017-12-03	0	0	25.93	0
51	b26	2017-12-08 -> 2017-12-11	0	0	26.13	0
52	b26	2017-12-13 -> 2017-12-17	0	0	26.45	0
53	b27	2017-12-06 -> 2017-12-13	0	0	26.4	0
54	b27	2017-12-16 -> 2017-12-16	0	0	26.82	0
55	b28	2017-12-01 -> 2017-12-04	0	0	26.78	0
56	b28	2017-12-11 -> 2017-12-13	0	27.89	0	0
57	b29	2017-12-21 -> 2017-12-26	0	0	28.96	0
58	b29	2017-12-01 -> 2017-12-30	0	0	27.32	1.88
59	b30	2017-12-10 -> 2017-12-12	0	0	29.77	0
60	b30	2017-12-03 -> 2017-12-09	0	0	30.21	0
61	b31	2017-12-07 -> 2017-12-23	455.26	0	0	0
62	b31	2017-12-01 -> 2017-12-17	0	0	31.02	0
63	b32	2017-12-21 -> 2017-12-28	0	0	32.49	0
64	b32	2017-12-01 -> 2017-12-05	32.9	0	0	0
65	b33	2017-12-01 -> 2017-12-03	0	0	33.08	0
66	b33	2017-12-07 -> 2017-12-19	0	0	34.12	0
67	b34	2017-12-04 -> 2017-12-30	0	0	35.22	0
68	b34	2017-12-01 -> 2017-12-03	0	35.3	0	0
69	b35	2017-12-01 -> 2017-12-15	0	0	36.97	0
70	b35	2017-12-12 -> 2017-12-18	0	0	37.68	0
71	b36	2017-12-08 -> 2017-12-12	0	0	38.29	0
72	b36	2017-12-16 -> 2017-12-19	0	39.7	0	0
73	b37	2017-12-21 -> 2017-12-30	0	0	41.7	0
74	b37	2017-12-01 -> 2017-12-30	0	0	41.51	0
75	b38	2017-12-01 -> 2017-12-09	0	0	46.48	0
76	b38	2017-12-27 -> 2017-12-29	0	0	47.58	0
77	b39	2017-12-04 -> 2017-12-28	0	0	34.92	13.16
78	b39	2017-12-01 -> 2017-12-20	0	2.53	25.41	20.86
79	b40	2017-12-01 -> 2017-12-04	0	0	50.25	0
80	b40	2017-12-13 -> 2017-12-16	0	0	50.56	0
81	b41	2017-12-01 -> 2017-12-04	0	0	51.46	0
82	b41	2017-12-15 -> 2017-12-18	0	0	53.82	0
83	b42	2017-12-07 -> 2017-12-18	0	0	53.75	0
84	b42	2017-12-01 -> 2017-12-23	0	3.51	50.67	0
85	b43	2017-12-05 -> 2017-12-20	0	0	48.35	5.91
86	b43	2017-12-20 -> 2017-12-30	0	0	54.79	0
87	b44	2017-12-01 -> 2017-12-05	0	0	54.66	0
88	b44	2017-12-01 -> 2017-12-09	0	0	55.91	0
89	b45	2017-12-07 -> 2017-12-08	0	0	56.03	0
90	b45	2017-12-01 -> 2017-12-07	0	0	56.24	0
91	b46	2017-12-05 -> 2017-12-10	0	0	56.67	1.55
92	b46	2017-12-20 -> 2017-12-26	58.95	0	0	0
93	b47	2017-12-01 -> 2017-12-20	0	58.88	0	0
94	b47	2017-12-01 -> 2017-12-08	0	0	59.19	0
95	b48	2017-12-28 -> 2017-12-31	0	0	60.6	0
96	b48	2017-12-01 -> 2017-12-07	0	0	60.39	0
97	b49	2017-12-01 -> 2017-12-15	0	0	61.13	0
98	b49	2017-12-04 -> 2017-12-30	0	0	62.87	0
99	b50	2017-12-04 -> 2017-12-06	0	0	65.06	0
100	b50	2017-12-06 -> 2017-12-28	0	0	65.52	0
101	b51	2017-12-01 -> 2017-12-15	0	0	65.51	0
102	b51	2017-12-15 -> 2017-12-27	0	0	66.78	0
103	b52	2017-12-01 -> 2017-12-18	0	0	69.39	0
104	b52	2017-12-10 -> 2017-12-26	0	0	70.56	0
105	b53	2017-12-01 -> 2017-12-12	0	0	21.35	49.68
106	b53	2017-12-01 -> 2017-12-09	0	0	71.14	0
107	b54	2017-12-01 -> 2017-12-30	0	0	72.49	0
108	b54	2017-12-01 -> 2017-12-30	0	0	73.27	0
109	b55	2017-12-01 -> 2017-12-30	0	0	73.53	0
110	b55	2017-12-01 -> 2017-12-22	0	0	75.24	0
111	b56	2017-12-27 -> 2017-12-30	0	0	75.77	0
112	b56	2017-12-03 -> 2017-12-15	0	0	75.2	0
113	b57	2017-12-01 -> 2017-12-03	0	0	77.82	0
114	b57	2017-12-01 -> 2017-12-07	0	0	78.27	0
115	b58	2017-12-01 -> 2017-12-19	0	78.5	0	0
116	b58	2017-12-01 -> 2017-12-19	0	0	79.01	0
117	b59	2017-12-12 -> 2017-12-16	0	0	79.33	0
118	b59	2017-12-26 -> 2017-12-30	0	0	80.54	0
119	b60	2017-12-01 -> 2017-12-25	0	0	81.06	0
120	b60	2017-12-21 -> 2017-12-30	0	0	83.37	0
121	b61	2017-12-11 -> 2017-12-31	0	84.81	0	0.31
122	b61	2017-12-29 -> 2017-12-30	0	0	86.13	0
123	b62	2017-12-04 -> 2017-12-17	0	0	86.5	0
124	b62	2017-12-01 -> 2017-12-28	0	87.7	0	0
125	b63	2017-12-01 -> 2017-12-31	0	87.93	0	0
126	b63	2017-12-01 -> 2017-12-05	0	0	89.58	0
127	b64	2017-12-05 -> 2017-12-30	0	0	91.98	0
128	b64	2017-12-22 -> 2017-12-30	0	0	97.14	0
129	b65	2017-12-01 -> 2017-12-10	0	0	98.35	0
130	b65	2017-12-01 -> 2017-12-05	0	0	98.78	0
131	b66	2017-12-21 -> 2017-12-31	0	0	101.05	0
132	b66	2017-12-14 -> 2017-12-16	0	0	0	204.03
133	b67	2017-12-04 -> 2017-12-13	0	0	96.24	5.28
134	b67	2017-12-28 -> 2017-12-31	74.84	0	29.57	0
135	b68	2017-12-07 -> 2017-12-20	0	0	60.53	44.7
136	b68	2017-12-01 -> 2017-12-27	0	0	107.93	0
137	b69	2017-12-01 -> 2017-12-25	0	0	110.99	0
138	b69	2017-12-26 -> 2017-12-30	0	0	112.18	0
139	b70	2017-12-09 -> 2017-12-19	0	0	113.5	0
140	b70	2017-12-01 -> 2017-12-30	0	0	116.89	0
141	b71	2017-12-07 -> 2017-12-31	0	24.83	91.92	1.87
142	b71	2017-12-01 -> 2017-12-16	0	0	119.31	0
143	b72	2017-12-11 -> 2017-12-30	0	0	120.41	0
144	b72	2017-12-01 -> 2017-12-11	0	0	121.48	0
145	b73	2017-12-01 -> 2017-12-30	0	1.83	121.44	0
146	b73	2017-12-11 -> 2017-12-28	0	100.61	0	28.38
147	b74	2017-12-01 -> 2017-12-31	0	46.56	83.41	0
148	b74	2017-12-20 -> 2017-12-30	0	0	132.12	0
149	b75	2017-12-01 -> 2017-12-23	0	0	132.28	0
150	b75	2017-12-08 -> 2017-12-30	0	5.41	121.3	10.29
151	b76	2017-12-01 -> 2017-12-17	0	0	137.46	0
152	b76	2017-12-20 -> 2017-12-30	0	0	139.82	0
153	b77	2017-12-01 -> 2017-12-09	0	0	138.77	0
154	b77	2017-12-30 -> 2017-12-31	0	70.57	72.23	0
155	b78	2017-12-01 -> 2017-12-12	0	0	143.87	0
156	b78	2017-12-05 -> 2017-12-24	0	0	145.86	0
157	b79	2017-12-12 -> 2017-12-30	0	0	146.53	0.31
158	b79	2017-12-01 -> 2017-12-11	0	0	146.98	0
159	b80	2017-12-17 -> 2017-12-30	0	0	156.59	0
160	b80	2017-12-02 -> 2017-12-30	0	49.72	107.23	0
161	b81	2017-12-01 -> 2017-12-25	0	0	160.8	0.31
162	b81	2017-12-01 -> 2017-12-30	0	0	161.51	0
163	b82	2017-12-02 -> 2017-12-13	0	4.84	157.72	0
164	b82	2017-12-29 -> 2017-12-30	0	8.29	156.16	0
165	b83	2017-12-01 -> 2017-12-19	0	0	164.6	0
166	b83	2017-12-15 -> 2017-12-29	0	0	167.46	1.87
167	b84	2017-12-01 -> 2017-12-30	0	0	169.98	0
168	b84	2017-12-21 -> 2017-12-29	0	0	172.24	0
169	b85	2017-12-01 -> 2017-12-11	170.76	0	0	0
170	b85	2017-12-01 -> 2017-12-21	139.34	0	38.46	0
171	b86	2017-12-01 -> 2017-12-25	0	0	177.51	0
172	b86	2017-12-10 -> 2017-12-19	0	0	179.61	0
173	b87	2017-12-19 -> 2017-12-31	0	3.5	178.5	0
174	b87	2017-12-27 -> 2017-12-30	0	97.25	90.62	0
175	b88	2017-12-01 -> 2017-12-31	0	0	187.1	0
176	b88	2017-12-01 -> 2017-12-31	0	192.96	0	0
177	b89	2017-12-01 -> 2017-12-31	0	0	179.89	13.08
178	b89	2017-12-04 -> 2017-12-07	0	192.45	0	0
179	b90	2017-12-01 -> 2017-12-15	0	0	192.59	0
180	b90	2017-12-01 -> 2017-12-29	0	0	200.83	0
181	b91	2017-12-01 -> 2017-12-27	0	0	210.43	0
182	b91	2017-12-13 -> 2017-12-30	0	0	212.94	0
183	b92	2017-12-15 -> 2017-12-25	0	0	214.48	0
184	b92	2017-12-01 -> 2017-12-08	0	0	65.89	152.68
185	b93	2017-12-18 -> 2017-12-30	0	0	231.98	0
186	b93	2017-12-06 -> 2017-12-29	89.71	0	142.31	0
187	b94	2017-12-11 -> 2017-12-29	0	0	236.69	0
188	b94	2017-12-01 -> 2017-12-11	0	0	238.18	0
189	b95	2017-12-15 -> 2017-12-27	0	0	243.22	0
190	b95	2017-12-01 -> 2017-12-30	0	0	243.02	0
191	b96	2017-12-01 -> 2017-12-31	0	0	245.75	0
192	b96	2017-12-01 -> 2017-12-18	246.13	0	0	0
193	b97	2017-12-12 -> 2017-12-30	0	0	248.85	0
194	b97	2017-12-01 -> 2017-12-07	0	252.21	0	0
195	b98	2017-12-16 -> 2017-12-30	0	0	264.76	0
196	b98	2017-12-01 -> 2017-12-23	0	0	266.3	0
197	b99	2017-12-01 -> 2017-12-29	0	0	269.46	0
198	b99	2017-12-01 -> 2017-12-18	0	0	270.02	0
199	b100	2017-12-01 -> 2017-12-30	0	95.01	177.66	0
200	b100	2017-12-15 -> 2017-12-21	0	0	271.29	1.88
201	b101	2017-12-01 -> 2017-12-20	0	0	277.78	0
202	b101	2017-12-01 -> 2017-12-22	0	0	279.47	0
203	b102	2017-12-20 -> 2017-12-25	0	0	0	75.18
204	b102	2017-12-01 -> 2017-12-30	0	127.97	153.83	0
205	b103	2017-12-01 -> 2017-12-11	0	0	282.8	0
206	b103	2017-12-06 -> 2017-12-23	0	0	285.46	0
207	b104	2017-12-10 -> 2017-12-30	0	0	291.49	0
208	b104	2017-12-21 -> 2017-12-27	0	0	285.27	9.19
209	b105	2017-12-13 -> 2017-12-30	0	0	302.52	0
210	b105	2017-12-01 -> 2017-12-17	0	0	305.73	0
211	b106	2017-12-23 -> 2017-12-30	0	0	52.39	14.76
212	b106	2017-12-23 -> 2017-12-27	0	1.75	310.11	0
213	b107	2017-12-18 -> 2017-12-27	0	0	311.4	0
214	b107	2017-12-18 -> 2017-12-27	0	0	311.32	0
215	b108	2017-12-22 -> 2017-12-28	0	0	65.13	0
216	b108	2017-12-11 -> 2017-12-27	0	0	310.36	0
217	b109	2017-12-05 -> 2017-12-27	0	0	0	64.13
218	b109	2017-12-13 -> 2017-12-27	0	0	310.33	0
219	b110	2017-12-22 -> 2017-12-29	0	0	62.34	0
220	b110	2017-12-07 -> 2017-12-27	0	0	310.01	0
221	b110	2017-12-12 -> 2017-12-25	0	8.27	301.72	0
222	b110	2017-12-19 -> 2017-12-29	0	0	312.99	0
223	b110	2017-12-13 -> 2017-12-30	0	0	312.48	0
224	b110	2017-12-07 -> 2017-12-19	0	10.44	300.81	0
225	b110	2017-12-11 -> 2017-12-29	0	0	312.25	0
226	b110	2017-12-01 -> 2017-12-22	0	0	290.75	28.19
227	b110	2017-12-05 -> 2017-12-28	0	0	0	57.98
228	b110	2017-12-01 -> 2017-12-30	0	0	328.67	0
229	b110	2017-12-01 -> 2017-12-29	0	0	331.34	0.31
230	b115	2017-12-01 -> 2017-12-13	330.83	0	0	0
231	b116	2017-12-01 -> 2017-12-17	0	0	334.37	0
232	b116	2017-12-05 -> 2017-12-30	0	0	339.49	0
233	b117	2017-12-01 -> 2017-12-21	0	0	341.89	0
234	b117	2017-12-01 -> 2017-12-31	342.5	0	0	0
235	b118	2017-12-01 -> 2017-12-15	0	0	349.6	0
236	b118	2017-12-01 -> 2017-12-26	0	0	350.66	0
237	b119	2017-12-01 -> 2017-12-18	0	0	355.26	0
238	b119	2017-12-22 -> 2017-12-29	0	0	51.19	0
239	b120	2017-12-01 -> 2017-12-31	0	0	359.32	0
240	b120	2017-12-01 -> 2017-12-31	0	0	360.11	0.31
241	b121	2017-12-01 -> 2017-12-23	362.68	0	0	0
242	b121	2017-12-01 -> 2017-12-11	0	373.21	0	0
243	b122	2017-12-06 -> 2017-12-17	0	379.28	0	0
244	b122	2017-12-07 -> 2017-12-09	0	0	47.31	0
245	b123	2017-12-15 -> 2017-12-27	0	0	384.19	0
246	b123	2017-12-01 -> 2017-12-31	0	383.27	0	0
247	b124	2017-12-01 -> 2017-12-31	0	216	169.81	0
248	b124	2017-12-07 -> 2017-12-29	0	0	0	41.3
249	b125	2017-12-22 -> 2017-12-28	0	0	39.74	0
250	b125	2017-12-01 -> 2017-12-16	0	386.11	0	0
251	b126	2017-12-22 -> 2017-12-27	0	0	39.56	0
252	b126	2017-12-20 -> 2017-12-26	0	0	389.36	0
253	b127	2017-12-01 -> 2017-12-27	0	172.79	240.49	0
254	b127	2017-12-01 -> 2017-12-31	302.88	15.64	99.26	0
255	b128	2017-12-22 -> 2017-12-29	0	0	36.42	0
256	b128	2017-12-22 -> 2017-12-30	0	0	35.99	0
257	b129	2017-12-01 -> 2017-12-27	0	418.24	0	0
258	b129	2017-12-22 -> 2017-12-31	0	0	422.78	0
259	b130	2017-12-01 -> 2017-12-27	0	0	420.82	0
260	b130	2017-12-01 -> 2017-12-14	0	193.11	115.78	119.33
261	b131	2017-12-01 -> 2017-12-30	0	0	430.7	0
262	b131	2017-12-01 -> 2017-12-29	0	0	451.88	0
263	b132	2017-12-01 -> 2017-12-16	0	0	451.48	0
264	b132	2017-12-01 -> 2017-12-28	0	88.88	374.38	0
265	b133	2017-12-01 -> 2017-12-15	0	462.46	0	0
266	b133	2017-12-01 -> 2017-12-25	0	0	463.91	0
267	b134	2017-12-14 -> 2017-12-19	0	0	0	28.99
268	b134	2017-12-24 -> 2017-12-27	0	0	470.19	0
269	b135	2017-12-12 -> 2017-12-31	0	0	469.01	0
270	b135	2017-12-05 -> 2017-12-29	96.05	336.93	34.97	0
271	b136	2017-12-06 -> 2017-12-26	0	0	0	26.8
272	b136	2017-12-05 -> 2017-12-28	0	0	468.29	0
273	b137	2017-12-07 -> 2017-12-27	0	34.98	433.83	0
274	b137	2017-12-09 -> 2017-12-31	386.84	0	96.27	0
275	b138	2017-12-01 -> 2017-12-30	0	0	485.57	0
276	b138	2017-12-19 -> 2017-12-30	0	0	0	26
277	b139	2017-12-01 -> 2017-12-29	0	0	511.51	0
278	b139	2017-12-01 -> 2017-12-30	0	105.97	408.64	0.99
279	b140	2017-12-14 -> 2017-12-28	0	509.52	33.47	0
280	b140	2017-12-01 -> 2017-12-30	0	0	539.13	9.69
281	b141	2017-12-01 -> 2017-12-29	0	264.29	367.12	0
282	b141	2017-12-16 -> 2017-12-31	0	3.14	685.76	0
283	b142	2017-12-15 -> 2017-12-29	0	0	699.81	0
284	b142	2017-12-01 -> 2017-12-31	0	46.53	694.21	0
285	b143	2017-12-05 -> 2017-12-31	0	0	743.39	0
286	b143	2017-12-01 -> 2017-12-30	0	0	743.58	0
287	b144	2017-12-01 -> 2017-12-23	0	743.79	0	0
288	b144	2017-12-01 -> 2017-12-24	0	399.4	369.64	0
289	b145	2017-12-01 -> 2017-12-21	0	0	0	23.31
290	b145	2017-12-01 -> 2017-12-30	0	0	780.93	0
291	b146	2017-12-01 -> 2017-12-30	0	0	787.07	0
292	b146	2017-12-19 -> 2017-12-27	0	789.76	0	0
293	b147	2017-12-05 -> 2017-12-22	0	0	791.07	0
294	b147	2017-12-28 -> 2017-12-29	0	0	815.29	0
295	b148	2017-12-22 -> 2017-12-30	0	0	20.79	0
296	b148	2017-12-01 -> 2017-12-30	0	0	0	20.19
297	b149	2017-12-01 -> 2017-12-26	0	0	0	20.03
298	b149	2017-12-01 -> 2017-12-27	0	768.42	89.31	0
299	b150	2017-12-01 -> 2017-12-30	0	772.85	126.21	0
300	b150	2017-12-22 -> 2017-12-30	0	0	18.58	0
301	b151	2017-12-09 -> 2017-12-21	0	0	0	18.33
302	b151	2017-12-29 -> 2017-12-30	0	0	17.54	0
303	b152	2017-12-22 -> 2017-12-30	0	0	16.28	0
304	b152	2017-12-01 -> 2017-12-30	0	0	912.63	0
305	b153	2017-12-12 -> 2017-12-27	389.43	264.39	281.8	0
306	b153	2017-12-01 -> 2017-12-29	0	0	951.01	0
307	b154	2017-12-01 -> 2017-12-30	0	0	1013.89	0
308	b154	2017-12-01 -> 2017-12-27	0	0	1012.94	8.8
309	b155	2017-12-06 -> 2017-12-30	0	0	0	15.54
310	b155	2017-12-01 -> 2017-12-28	0	0	871.33	164.55
311	b156	2017-12-01 -> 2017-12-23	0	101.15	881.68	62.08
312	b156	2017-12-01 -> 2017-12-31	0	0	0	14.41
313	b157	2017-12-12 -> 2017-12-28	0	1171.38	0	0
314	b157	2017-12-26 -> 2017-12-29	0	0	13.97	0
315	b158	2017-12-01 -> 2017-12-30	0	0	1170.8	0
316	b158	2017-12-28 -> 2017-12-30	0	0	0	13.46
317	b159	2017-12-04 -> 2017-12-21	0	0	0	13.37
318	b159	2017-12-22 -> 2017-12-28	0	0	13.17	0
319	b160	2017-12-09 -> 2017-12-17	0	1168.26	0	0
320	b160	2017-12-11 -> 2017-12-12	0	0	0	12.74
321	b161	2017-12-01 -> 2017-12-28	0	0	0	11.88
322	b161	2017-12-08 -> 2017-12-27	0	0	0	11.54
323	b162	2017-12-22 -> 2017-12-27	0	0	11.41	0
324	b162	2017-12-01 -> 2017-12-27	0	0	1131.69	51.23
325	b163	2017-12-01 -> 2017-12-30	0	0	1356.93	0
326	b163	2017-12-11 -> 2017-12-28	0	0	0	10.93
327	b164	2017-12-01 -> 2017-12-25	0	1472.29	0	0
328	b164	2017-12-14 -> 2017-12-14	0	0	0	10.26
329	b165	2017-12-01 -> 2017-12-23	0	0	1506.3	0
330	b165	2017-12-29 -> 2017-12-30	0	0	0	9.72
331	b166	2017-12-01 -> 2017-12-30	0	0	1561.1	0
332	b166	2017-12-22 -> 2017-12-29	0	0	8.86	0
333	b167	2017-12-02 -> 2017-12-24	0	875.59	686.3	0
334	b167	2017-12-28 -> 2017-12-28	0	0	8.55	0
335	b168	2017-12-25 -> 2017-12-28	0	0	0	8.15
336	b168	2017-12-02 -> 2017-12-11	0	0	0	8.07
337	b169	2017-12-06 -> 2017-12-22	0	0	0	7.78
338	b169	2017-12-12 -> 2017-12-30	0	0	0	7.78
339	b170	2017-12-19 -> 2017-12-26	0	0	0	7.51
340	b170	2017-12-18 -> 2017-12-28	0	0	0	7.19
341	b171	2017-12-06 -> 2017-12-18	0	0	0	6.89
342	b171	2017-12-19 -> 2017-12-31	0	22.16	1566.32	0
343	b172	2017-12-01 -> 2017-12-29	0	1268.35	391.21	0
344	b172	2017-12-01 -> 2017-12-29	0	0	0	6.54
345	b173	2017-12-27 -> 2017-12-27	0	0	0	5.92
346	b173	2017-12-22 -> 2017-12-30	0	0	5.84	0
347	b174	2017-12-22 -> 2017-12-23	0	0	5.78	0
348	b174	2017-12-04 -> 2017-12-31	0	0	0	5.61
349	b175	2017-12-23 -> 2017-12-24	0	0	0	5.33
350	b175	2017-12-21 -> 2017-12-22	0	0	0	5.32
351	b176	2017-12-12 -> 2017-12-21	0	0	0	5.31
352	b176	2017-12-01 -> 2017-12-29	0	625.6	1363.14	0
353	b177	2017-12-01 -> 2017-12-30	0	0	0	5
354	b177	2017-12-01 -> 2017-12-31	0	0	0	4.89
355	b178	2017-12-11 -> 2017-12-29	0	0	0	4.67
356	b178	2017-12-04 -> 2017-12-21	0	0	0	4.66
357	b179	2017-12-07 -> 2017-12-11	0	0	0	4.35
358	b179	2017-12-07 -> 2017-12-14	0	0	0	4.35
359	b180	2017-12-04 -> 2017-12-07	0	0	0	4.35
360	b180	2017-12-01 -> 2017-12-03	0	0	0	4.34
361	b181	2017-12-01 -> 2017-12-31	0	0	2071.82	0
362	b181	2017-12-30 -> 2017-12-30	0	0	0	4.08
363	b182	2017-12-22 -> 2017-12-27	0	0	0	4.07
364	b182	2017-12-06 -> 2017-12-24	0	0	0	4.06
365	b183	2017-12-05 -> 2017-12-28	0	0	0	4.05
366	b183	2017-12-27 -> 2017-12-30	0	0	3.89	0
367	b184	2017-12-22 -> 2017-12-27	0	0	0	3.76
368	b184	2017-12-01 -> 2017-12-01	0	0	0	3.72
369	b185	2017-12-07 -> 2017-12-31	0	0	0	3.71
370	b185	2017-12-30 -> 2017-12-30	0	0	0	3.45
371	b186	2017-12-22 -> 2017-12-27	0	0	0	3.45
372	b186	2017-12-21 -> 2017-12-21	0	0	0	3.45
373	b187	2017-12-13 -> 2017-12-29	0	0	0	3.42
374	b187	2017-12-29 -> 2017-12-30	0	0	0	3.13
375	b188	2017-12-19 -> 2017-12-19	0	0	0	3.12
376	b188	2017-12-13 -> 2017-12-24	0	0	0	3.12
377	b189	2017-12-14 -> 2017-12-26	0	0	0	3.11
378	b189	2017-12-01 -> 2017-12-26	0	2103.39	0	0
379	b190	2017-12-21 -> 2017-12-30	0	19.33	2349.75	0
380	b190	2017-12-01 -> 2017-12-31	0	0	0	2.81
381	b191	2017-12-01 -> 2017-12-08	0	0	0	2.8
382	b191	2017-12-07 -> 2017-12-11	0	0	0	2.8
383	b192	2017-12-01 -> 2017-12-28	1285.13	0	1557.05	0
384	b192	2017-12-20 -> 2017-12-25	0	0	0	2.51
385	b193	2017-12-14 -> 2017-12-25	0	0	0	2.5
386	b193	2017-12-08 -> 2017-12-20	0	0	0	2.49
387	b194	2017-12-11 -> 2017-12-28	0	0	0	2.49
388	b194	2017-12-01 -> 2017-12-30	0	0	0	2.48
389	b195	2017-12-01 -> 2017-12-24	0	2984	0	0
390	b195	2017-12-15 -> 2017-12-21	0	0	0	2.18
391	b196	2017-12-13 -> 2017-12-23	0	0	0	2.18
392	b196	2017-12-07 -> 2017-12-11	0	0	0	2.17
393	b197	2017-12-13 -> 2017-12-13	0	0	0	2.17
394	b197	2017-12-01 -> 2017-12-01	0	0	0	2.17
395	b198	2017-12-04 -> 2017-12-28	0	0	0	1.96
396	b198	2017-12-11 -> 2017-12-13	0	0	0	1.96
397	b199	2017-12-22 -> 2017-12-28	0	0	1.92	0
398	b199	2017-12-16 -> 2017-12-26	0	0	0	1.88
399	b200	2017-12-20 -> 2017-12-20	0	0	0	1.88
400	b200	2017-12-13 -> 2017-12-27	0	0	0	1.87
401	b201	2017-12-13 -> 2017-12-19	0	0	0	1.87
402	b201	2017-12-04 -> 2017-12-04	0	0	0	1.86
403	b202	2017-12-19 -> 2017-12-30	0	0	0	1.57
404	b202	2017-12-23 -> 2017-12-31	0	0	0	1.57
405	b203	2017-12-23 -> 2017-12-29	0	0	0	1.57
406	b203	2017-12-02 -> 2017-12-31	0	0	0	1.56
407	b204	2017-12-15 -> 2017-12-15	0	0	0	1.56
408	b204	2017-12-03 -> 2017-12-26	0	0	0	1.56
409	b205	2017-12-11 -> 2017-12-22	0	0	0	1.56
410	b205	2017-12-26 -> 2017-12-29	0	0	3550.8	0
411	b206	2017-12-29 -> 2017-12-30	0	0	1.37	0
412	b206	2017-12-27 -> 2017-12-28	0	0	0	1.25
413	b207	2017-12-11 -> 2017-12-19	0	0	0	1.24
414	b207	2017-12-04 -> 2017-12-30	0	0	0	1.24
415	b208	2017-12-11 -> 2017-12-11	0	0	0	1.24
416	b208	2017-12-13 -> 2017-12-13	0	0	0	1.24
417	b209	2017-12-04 -> 2017-12-13	0	0	0	1.24
418	b209	2017-12-04 -> 2017-12-31	2505.15	385.44	723.58	0
419	b210	2017-12-01 -> 2017-12-31	2235.2	419.45	2263.12	0
420	b210	2017-12-01 -> 2017-12-18	0	0	0	1
421	b211	2017-12-15 -> 2017-12-29	0	0	0	0.99
422	b211	2017-12-06 -> 2017-12-28	0	0	0	0.99
423	b212	2017-12-13 -> 2017-12-13	0	0	0	0.98
424	b212	2017-12-23 -> 2017-12-26	0	0	0	0.94
425	b213	2017-12-18 -> 2017-12-26	0	0	0	0.94
426	b213	2017-12-28 -> 2017-12-30	0	0	0	0.94
427	b214	2017-12-21 -> 2017-12-21	0	0	0	0.94
428	b214	2017-12-28 -> 2017-12-28	0	0	0	0.94
429	b215	2017-12-14 -> 2017-12-14	0	0	0	0.93
430	b215	2017-12-06 -> 2017-12-08	0	0	0	0.93
431	b216	2017-12-22 -> 2017-12-28	0	0	0.83	0
432	b216	2017-12-01 -> 2017-12-03	0	0	0	0.77
433	b217	2017-12-04 -> 2017-12-07	0	0	0	0.77
434	b217	2017-12-22 -> 2017-12-28	0	0	0.65	0
435	b218	2017-12-23 -> 2017-12-23	0	0	0	0.63
436	b218	2017-12-23 -> 2017-12-27	0	0	0	0.63
437	b219	2017-12-26 -> 2017-12-28	0	0	0	0.63
438	b219	2017-12-21 -> 2017-12-21	0	0	0	0.63
439	b220	2017-12-01 -> 2017-12-26	0	0	0	0.62
440	b220	2017-12-12 -> 2017-12-18	0	0	0	0.62
441	b221	2017-12-15 -> 2017-12-15	0	0	0	0.62
442	b221	2017-12-04 -> 2017-12-19	0	0	0	0.62
443	b222	2017-12-01 -> 2017-12-21	0	0	0	0.62
444	b222	2017-12-04 -> 2017-12-04	0	0	0	0.62
445	b223	2017-12-04 -> 2017-12-04	0	0	0	0.62
446	b223	2017-12-01 -> 2017-12-12	6208.44	0	0	0
447	b224	2017-12-01 -> 2017-12-31	0	37.67	6815.38	0
448	b224	2017-12-30 -> 2017-12-30	0	0	0	0.31
449	b225	2017-12-23 -> 2017-12-29	0	0	0	0.31
450	b225	2017-12-29 -> 2017-12-29	0	0	0	0.31
451	b226	2017-12-28 -> 2017-12-30	0	0	0	0.31
452	b226	2017-12-05 -> 2017-12-30	0	0	0	0.31
453	b227	2017-12-17 -> 2017-12-17	0	0	0	0.31
454	b227	2017-12-19 -> 2017-12-19	0	0	0	0.31
455	b228	2017-12-15 -> 2017-12-17	0	0	0	0.31
456	b228	2017-12-14 -> 2017-12-14	0	0	0	0.31
457	b229	2017-12-14 -> 2017-12-14	0	0	0	0.31
458	b229	2017-12-05 -> 2017-12-09	0	0	0	0.31
459	b230	2017-12-05 -> 2017-12-05	0	0	0	0.31
460	b230	2017-12-11 -> 2017-12-11	0	0	0	0.31
461	b231	2017-12-06 -> 2017-12-12	0	0	0	0.31
462	b231	2017-12-14 -> 2017-12-14	0	0	0	0.31
463	b232	2017-12-09 -> 2017-12-09	0	0	0	0.31
464	b232	2017-12-13 -> 2017-12-13	0	0	0	0.31
465	b233	2017-12-03 -> 2017-12-03	0	0	0	0.31
466	b233	2017-12-22 -> 2017-12-28	0	0	0.29	0
467	b234	2017-12-22 -> 2017-12-22	0	0	0.28	0
468	b234	2017-12-19 -> 2017-12-28	0	0	0.26	0
469	b235	2017-12-01 -> 2017-12-21	0	249.44	10169.3	0
470	b235	2017-12-28 -> 2017-12-28	0	0	0.04	0

Formulas and Functions

Forum Discussion

Microsoft excel average function.

Data

Data

1 Reply

Resources

Data

Data

Data

Data