Reddit - test - Google Sheets

	A	B	C	D	E	F	G	I	J
1		GAMEMODE
2
3
4		LIGHT	NB	%	AV. KILL	AV. DMG	WR
5	SPEC.	CLOAKING DEVICE	66	4%	4,8	3791	3,03 %
6		EVASIVE DASH	1450	94%	5,3	4164	10,14 %
7		GRAPPLING HOOK	27	2%	3,3	2675	0 %
8	WEAPON	93R	840	54%	5,5	4299	10,36 %
9		DAGGER	0	0%
10		LH1	64	4%	4,4	4194	20,31 %
11		M11	195	13%	6,1	4295	14,87 %
12		SH1900	46	3%	5,5	3546	0 %
13		SR-84	5	0%	1,8	2127	0 %	previous formulas :
14		SWORD	36	2%	4,8	3236	5,56 %
15		V9S	5	0%	5,6	3747	0 %	C21	=SOMMEPROD((MATCHES!A:A=$C$1)(MATCHES!B:B=$B$4)(MATCHES!E:G=B21))
16		XP-54	84	5%	4,4	3749	0 %	E21	=SIERREUR(MOYENNE(FILTER(MATCHES!H:H;MATCHES!A:A=$C$1;MATCHES!B:B=$B$4;(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21)));"")
17		KNIVES	24	2%	3,3	2660	0 %	G21	=SIERREUR(SI(SI($C$1)="CASHOUT";MOYENNE(FILTER(MATCHES!O:O;MATCHES!A:A=$C$1;MATCHES!B:B=$B$4;(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21)));ARRONDI(NB.SI(FILTER(MATCHES!O:O;MATCHES!A:A=$C$1;MATCHES!B:B=$B$4;(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21));"W")/C21;2)*100&" %");"")
18		RECURVE BOW	38	2%	4,7	4004	7,89 %
19		M26 MATTER	20	1%	4,8	3275	5 %	new formulas (not working) :
20		ARN-220	185	12%	4,6	3982	7,57 %
21	GADGETS	BREACH CHARGE	0	0%				C21	=SOMMEPROD((MATCHES!A:A=SI($C$1="";"";$C$1))(MATCHES!B:B=$B$4)*(MATCHES!E:G=B21))
22		GATEWAY	0	0%				E21	=SIERREUR(MOYENNE(FILTER(MATCHES!H:H;MATCHES!A:A=SI($C$1="";"*";$C$1);MATCHES!B:B=$B$4;(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21)));"")
23		GLITCH GRENADE	0	0%				G21	=SIERREUR(SI(SI($C$1="";"";$C$1)="CASHOUT";MOYENNE(FILTER(MATCHES!O:O;MATCHES!A:A=SI($C$1="";"";$C$1);MATCHES!B:B=$B$4;(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21)));ARRONDI(NB.SI(FILTER(MATCHES!O:O;MATCHES!A:A=SI($C$1="";"";$C$1);MATCHES!B:B=$B$4;(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21));"W")/C21;2)100&" %");"")
24		GRAVITY VORTEX	0	0%
25		H+ INFUSER	0	0%
26		SONAR GRENADE	0	0%
27		NULLIFIER	0	0%
28		THERMAL BORE	0	0%
29		THERMAL VISION	0	0%
30		TRACKING DART	0	0%
31		VANISHING BOMB	0	0%
32		FLASHBANG	0	0%
33		FRAG GRENADE	0	0%
34		GAS GRENADE	0	0%
35		GOO GRENADE	0	0%
36		PYRO GRENADE	0	0%
37		SMOKE GRENADE	0	0%
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100