sumif date
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
R$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMN
1
Valor Parcela
2
2011-06-0808/06/2011
3
2011-09-21R$ 108,7021/09/2011
4
2011-11-23R$ 33,6623/11/2011-372,21
5
2011-12-06R$ 46,8306/12/201100,00
6
2012-01-06R$ 46,83
7
2012-01-2706/01/20123.326,71=sum(B2:B34)
8
2012-02-03R$ 49,9003/02/20122.248,87=SUMIF(A2:A34;">="&A36;B2:B34)
9
2012-02-06R$ 146,8306/02/2012838,75=sumif(A2:A34;"<="&A35;B2:B34)R$ 1.764,44
10
2012-02-06R$ 123,7006/02/2012723,52=SUM(B2:B34)-sumif(A2:A34;">="&A36;B2:B34)-sumif(A2:A34;"<="&A35;B2:B34)
11
2012-02-06R$ 282,3006/02/2012
12
2012-02-08R$ 33,6608/02/2012
13
2012-02-13R$ 99,9013/02/2012
14
2012-02-13R$ 143,6913/02/20123.326,71SUM(B2:B33)
15
2012-02-23R$ 33,5823/02/20121.714,541714,54
16
2012-03-03R$ 49,9003/03/20121.764,44sumif(A2:A33;"<="&A35;B2:B33)
17
2012-03-06R$ 46,8306/03/2012
18
2012-03-06R$ 282,3006/03/2012723,52SUM(B2:B33)-sumif(A2:A33;">="&A36;B2:B33)-sumif(A2:A33;"<="&A35;B2:B33)
19
2012-03-08R$ 33,6608/03/20123.137,52R$ 723,520000000001
20
2012-03-13R$ 99,9013/03/2012838,75
21
2012-03-13R$ 108,7013/03/201240.912,00
22
2012-04-03R$ 49,9003/04/201240.915,001143,23
23
2012-04-06R$ 46,8306/04/20124.805,23
24
2012-04-06R$ 282,3006/04/201210
25
2012-04-23R$ 33,5823/04/2012#ERROR!
26
2012-05-03R$ 49,9003/05/20122.851,60R$ 1.484,95
27
2012-05-06R$ 46,8306/05/201246,83
28
2012-05-06R$ 282,3006/05/2012
29
2012-06-03R$ 49,9003/06/2012
30
2012-06-06R$ 282,3006/06/20120
31
2012-07-03R$ 49,9003/07/20127
32
2012-07-06R$ 282,3006/07/20120
33
2012-07-19R$ 49,9019/07/2012
34
2012-08-03R$ 49,9003/08/2012
35
2012-02-0606/02/2012-742,02
36
2012-03-13R$ 3.326,7113/03/2012
37
2012-02-0630/04/20122990,89
38
2012-03-131.266,85
39
4.496,63
40
0,00
41
42
46,83
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
Loading...
 
 
 
Amex Green
Página2
Página3
Página4