QW-002 FormulaBerry Percentage Formulas — Worked Examples

	A	B	C	D
1
2	Percentage of a total
3
4	Category	Sales	Share of total
5	Services	1,200	30.0%
6	Subscriptions	1,800	45.0%
7	Training	600	15.0%
8	Other	400	10.0%
9	Total	4,000	100.0%
10
11	Illustrative data. Change the inputs in column B; shares recalculate.
12
13
14	Overall rate from unequal groups
15
16	Campaign	Sign-ups	Visitors	Conversion rate
17	Campaign A	10	100	10.0%
18	Campaign B	5	10	50.0%
19	Combined	15	110	13.6%
20
21	Edit C18 to 100. The combined rate changes from 13.6% to 7.5%.
22
23	For an overall rate, divide matching totals; do not average row rates.
24
25
26	File > Make a copy gives you an editable version, when access permits.
27
28	Examples are fictional. No add-on or account beyond Google Sheets is needed.
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