Function by Color - custom functions - examples

	A	B	C	E
1
2
3
4
5		Functions for Google Sheets to work with colored cells
6
7		Author	Ablebits.com
8		Last update	12 Jul 2024
9		Tutorial URL	CELLCOLOR & VALUESBYCOLORALL: functions for Google Sheets to work with colored cells
10
11		Examples
12	•	VALUESBYCOLOR		Function by Color add-on for Google Sheets (Ablebits)
13	•	VALUESBYCOLOR vs VALUESBYCOLORALL
14	•	CELLCOLOR
15	•	IF color, then
16	•	COUNTIFS
17	•	SUMIFS
18
19
20				Power Tools add-on for Google Sheets (Ablebits)
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