SUMIF function with formula examples

	A	B
1	Sample SUMIF Spreadsheet
2	The spreadsheet shows how to use the SUMIF function to conditinally sum cells.
3
4	Author	https://www.Ablebits.com
5	Last update	04/17/2024
6	Tutorial URL	https://www.ablebits.com/office-addins-blog/sumif-google-sheets/
7
8	Examples
9	Basic SUMIF formula
10	SUMIF with text criterion (exact match)
11	SUMIF with wildcard characters (partial match)
12	Case-sensitive SUMIF formula
13	Sum if greater than or less than
14	Sum if equal or not equal to
15	SUMIF formulas for dates
16	Sum if blank or non-blank
17	SUMIF with multiple criteria (OR logic)
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