SUMIF Example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQR
1
YearQuarterTransactionNameRevenue ($k)
2
2010Q3AJohn1000
3
2010Q3BJohn500
4
2010Q3AJana2500
5
2010Q4AJohn1300
6
2010Q4BJana2250
7
8
2011Q1AJohn1500
9
2011Q1BJana900
10
2011Q2AJohn1950
11
2011Q2BJana1600
12
13
Revenue earned by John in 2010 Q31500=sum(filter(E2:E11,D2:D11= "John",B2:B11="Q3",A2:A11=2010))
14
15
#Transactions > 1001 in 20113=count(filter(E2:E11,E2:E11>1000,A2:A11=2011))
16
17
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
Loading...