ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Thank you Trangstar888!
2
NOTE: English MUST be in column D. Because the formula is looking for English in Column D
3
All other languages can be in whichever column you like on row 3. The languages on row 3 are just labels.
4
5
HOW TO USE:
6
Copy the first segment's sub and paste it into D1
7
The formula fetches the sub from the following segment and displays it in E1
8
The charater count for English is displayed in F1
9
The character count for every language appears above the language's name.
10
IF a language is 95 or higher do NOT combine the segments.
11
12
NOTE 1: This spreadsheet is not foolproof. It will fail when a language is out of sync. When that happens, ignore that language's tally and check the character count manually
13
NOTE 2: Everyone must have editor access to use the calculator!
14
NOTE 3: ANY CS may make a copy of this template for their own use.
15
16
This spreadsheet is made in USA. It can fail in some countries because of the way formulas are written. If you want to convert it for your region,
17
 go to File ► Settings ►General tab.►Locale dropdown menu, ► select United States (or preferred country)► Save and reload to apply the changes.
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
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