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