Microsoft excel average function.

Occasional Visitor
Spoiler
 

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 USD
4How 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 D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040
Spoiler
 

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 USD
4How 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 D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040
1 Reply

@deokars43 

AVERAGE function

This 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 Excel

examble 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.

 

NikolinoDE

I know I don't know anything (Socrates)