SumIfs not working?

[Rich12]

GA, looked through the forum and found many examples of sumifs still not understanding why one of the formulas below will not work. All produce a 0 value output


Have tried multiple methods

=SUMIFS(F:F,C:C,">="&I55,D:D,"<="&J55)

=SUMIFS(F1:F724,C1:C724,">="&I56,D1:D724,"<="&J56)

=SUMIFS(F2:F727,C2:C727,">=08/01/2001",D2:D727,"<=07/31/2002")

=SUMIFS(F:F,C:C,">=08/01/2001",C:C,"<=07/31/2002")

Sample Data

Start	End	Number	Count	Dollars		Start Of Period	End Of Period
1/1/1997	1/31/1997	12B970031694	1	177.70		1/1/1997	12/31/1997
2/1/1997	2/28/1997	12B970411135	1	1898.38		2/1/1997	1/31/1998
2/1/1997	2/28/1997	12B970552787	1	112.00		3/1/1997	2/28/1998
2/1/1997	2/28/1997	12B970631460	1	1353.07		4/1/1997	3/31/1998
2/1/1997	2/28/1997	12D970640064	1	9460.00		5/1/1997	4/30/1998
2/1/1997	2/28/1997	12E980820910	1	10000.00		6/1/1997	5/31/1998
3/1/1997	3/31/1997	12B970622577	1	695.89		7/1/1997	6/30/1998
3/1/1997	3/31/1997	12E970780063	1	1000.00		8/1/1997	7/31/1998
3/1/1997	3/31/1997	12J971500266	1	2141245.31		9/1/1997	8/31/1998
4/1/1997	4/30/1997	12B971070387	1	833.00		10/1/1997	9/30/1998
4/1/1997	4/30/1997	12B971121881	1	1220.28		11/1/1997	10/31/1998
4/1/1997	4/30/1997	12D971151351	1	1000.00		12/1/1997	11/30/1998
4/1/1997	4/30/1997	12E970972057	1	1665.33		1/1/1998	12/31/1998
4/1/1997	4/30/1997	12E971270946	1	905.44		2/1/1998	1/31/1999
4/1/1997	4/30/1997	12E971280125	1	1667.39		3/1/1998	2/28/1999
4/1/1997	4/30/1997	12E971321342	1	11402.66		4/1/1998	3/31/1999
4/1/1997	4/30/1997	12F971120815	1	2394.60		5/1/1998	4/30/1999
4/1/1997	4/30/1997	12F971251275	1	3900.00		6/1/1998	5/31/1999
4/1/1997	4/30/1997	12F972610297	1	255.00		7/1/1998	6/30/1999
5/1/1997	5/31/1997	12B971270459	1	312.50		8/1/1998	7/31/1999
5/1/1997	5/31/1997	12B971692188	1	1784.70		9/1/1998	8/31/1999
5/1/1997	5/31/1997	12E971602000	1	8500.00		10/1/1998	9/30/1999
5/1/1997	5/31/1997	12G971410165	1	1017.33		11/1/1998	10/31/1999
6/1/1997	6/30/1997	12B971780856	1	3599.80		12/1/1998	11/30/1999
6/1/1997	6/30/1997	12E971970150	1	51000.00		1/1/1999	12/31/1999
7/1/1997	7/31/1997	12B971900845	1	256.70		2/1/1999	1/31/2000
7/1/1997	7/31/1997	12C980361884	1	848287.05		3/1/1999	2/29/2000
7/1/1997	7/31/1997	12E020360396	1	4500.00		4/1/1999	3/31/2000
7/1/1997	7/31/1997	12E972031346	1	40048.42		5/1/1999	4/30/2000
7/1/1997	7/31/1997	12E972870955	1	304.80		6/1/1999	5/31/2000
8/1/1997	8/31/1997	12B972180536	1	65.50		7/1/1999	6/30/2000
8/1/1997	8/31/1997	12E021300421	1	4201.00		8/1/1999	7/31/2000
8/1/1997	8/31/1997	12E972320121	1	23853.50		9/1/1999	8/31/2000
8/1/1997	8/31/1997	12E972932387	1	520.47		10/1/1999	9/30/2000
8/1/1997	8/31/1997	12E973090764	1	968.81		11/1/1999	10/31/2000
8/1/1997	8/31/1997	12E973090783	1	1289.51		12/1/1999	11/30/2000
9/1/1997	9/30/1997	12E002511138	1	204229.16		1/1/2000	12/31/2000
9/1/1997	9/30/1997	12E972800161	1	2088.00		2/1/2000	1/31/2001
9/1/1997	9/30/1997	12E973090814	1	587.33		3/1/2000	2/28/2001
9/1/1997	9/30/1997	12E973090831	1	423.62		4/1/2000	3/31/2001
9/1/1997	9/30/1997	12E973090838	1	6980.08		5/1/2000	4/30/2001
9/1/1997	9/30/1997	12F972750710	1	16304.71		6/1/2000	5/31/2001
9/1/1997	9/30/1997	12G972760011	1	5191.77		7/1/2000	6/30/2001
10/1/1997	10/31/1997	12E973142322	1	11209.43		8/1/2000	7/31/2001
10/1/1997	10/31/1997	12E980211315	1	14317.28		9/1/2000	8/31/2001
10/1/1997	10/31/1997	12E980361346	1	3369.00		10/1/2000	9/30/2001
10/1/1997	10/31/1997	12E981281290	1	64351.58		11/1/2000	10/31/2001
10/1/1997	10/31/1997	12F972790441	1	638.50		12/1/2000	11/30/2001
11/1/1997	11/30/1997	12B973352421	1	665.64		1/1/2001	12/31/2001
11/1/1997	11/30/1997	12D973300140	1	244108.23		2/1/2001	1/31/2002
11/1/1997	11/30/1997	12G980541683	1	24877.28		3/1/2001	2/28/2002
12/1/1997	12/31/1997	12B980052622	1	4487.50		4/1/2001	3/31/2002
12/1/1997	12/31/1997	12E973520161	1	10880.64		5/1/2001	4/30/2002
12/1/1997	12/31/1997	12E980230176	1	15000.00		6/1/2001	5/31/2002
12/1/1997	12/31/1997	12E980230207	1	1060.00		7/1/2001	6/30/2002
1/1/1998	1/31/1998		0	0.00		8/1/2001	7/31/2002
2/1/1998	2/28/1998	12B980431727	1	550.00		9/1/2001	8/31/2002
2/1/1998	2/28/1998	12E003211772	1	7574.54		10/1/2001	9/30/2002
2/1/1998	2/28/1998	12E980640947	1	11111.39		11/1/2001	10/31/2002
2/1/1998	2/28/1998	12E981051511	1	7638.00		12/1/2001	11/30/2002
2/1/1998	2/28/1998	12E981341401	1	121.51		1/1/2002	12/31/2002
3/1/1998	3/31/1998	12B981041973	1	59663.64		2/1/2002	1/31/2003
3/1/1998	3/31/1998	12E980892661	1	6415.98		3/1/2002	2/28/2003
3/1/1998	3/31/1998	12E981051631	1	2853.62		4/1/2002	3/31/2003
3/1/1998	3/31/1998	12E981201183	1	567.00		5/1/2002	4/30/2003
3/1/1998	3/31/1998	12G981180083	1	30177.60		6/1/2002	5/31/2003
3/1/1998	3/31/1998	12G981331831	1	1570.00		7/1/2002	6/30/2003
3/1/1998	3/31/1998	12G981550058	1	10462.80		8/1/2002	7/31/2003

<tbody>
</tbody>

 

[Aladin Akyurek]

Given that input in A:G, what do you want to compute? Please describe your goal in words.

 

[GR00007]

When I copied your sample data and pasted into a new spreadsheet column F was blank, which would explain zeros for all formula.
The Dollars column was E

 

[Rich12]

I'm looking to sum the count column, creating rolling 12 month counts, I did not paste in columns A or B and as I'm thinking about it would create some confusion as you are looking at the formula, there is a blank column that I'm using to separate the data from the calculated rolling 12 month values

 

[Rich12]

Year	Month	Start	End	Number	Count	Dollars		Start Of Period	End Of Period
1997	1	1/1/1997	1/31/1997	12B970031694	1	177.70		1/1/1997	12/31/1997
1997	2	2/1/1997	2/28/1997	12B970411135	1	1898.38		2/1/1997	1/31/1998
1997	2	2/1/1997	2/28/1997	12B970552787	1	112.00		3/1/1997	2/28/1998
1997	2	2/1/1997	2/28/1997	12B970631460	1	1353.07		4/1/1997	3/31/1998
1997	2	2/1/1997	2/28/1997	12D970640064	1	9460.00		5/1/1997	4/30/1998
1997	2	2/1/1997	2/28/1997	12E980820910	1	10000.00		6/1/1997	5/31/1998
1997	3	3/1/1997	3/31/1997	12B970622577	1	695.89		7/1/1997	6/30/1998
1997	3	3/1/1997	3/31/1997	12E970780063	1	1000.00		8/1/1997	7/31/1998
1997	3	3/1/1997	3/31/1997	12J971500266	1	2141245.31		9/1/1997	8/31/1998
1997	4	4/1/1997	4/30/1997	12B971070387	1	833.00		10/1/1997	9/30/1998
1997	4	4/1/1997	4/30/1997	12B971121881	1	1220.28		11/1/1997	10/31/1998
1997	4	4/1/1997	4/30/1997	12D971151351	1	1000.00		12/1/1997	11/30/1998
1997	4	4/1/1997	4/30/1997	12E970972057	1	1665.33		1/1/1998	12/31/1998
1997	4	4/1/1997	4/30/1997	12E971270946	1	905.44		2/1/1998	1/31/1999
1997	4	4/1/1997	4/30/1997	12E971280125	1	1667.39		3/1/1998	2/28/1999
1997	4	4/1/1997	4/30/1997	12E971321342	1	11402.66		4/1/1998	3/31/1999
1997	4	4/1/1997	4/30/1997	12F971120815	1	2394.60		5/1/1998	4/30/1999
1997	4	4/1/1997	4/30/1997	12F971251275	1	3900.00		6/1/1998	5/31/1999
1997	4	4/1/1997	4/30/1997	12F972610297	1	255.00		7/1/1998	6/30/1999
1997	5	5/1/1997	5/31/1997	12B971270459	1	312.50		8/1/1998	7/31/1999
1997	5	5/1/1997	5/31/1997	12B971692188	1	1784.70		9/1/1998	8/31/1999
1997	5	5/1/1997	5/31/1997	12E971602000	1	8500.00		10/1/1998	9/30/1999
1997	5	5/1/1997	5/31/1997	12G971410165	1	1017.33		11/1/1998	10/31/1999
1997	6	6/1/1997	6/30/1997	12B971780856	1	3599.80		12/1/1998	11/30/1999
1997	6	6/1/1997	6/30/1997	12E971970150	1	51000.00		1/1/1999	12/31/1999
1997	7	7/1/1997	7/31/1997	12B971900845	1	256.70		2/1/1999	1/31/2000
1997	7	7/1/1997	7/31/1997	12C980361884	1	848287.05		3/1/1999	2/29/2000
1997	7	7/1/1997	7/31/1997	12E020360396	1	4500.00		4/1/1999	3/31/2000
1997	7	7/1/1997	7/31/1997	12E972031346	1	40048.42		5/1/1999	4/30/2000
1997	7	7/1/1997	7/31/1997	12E972870955	1	304.80		6/1/1999	5/31/2000
1997	8	8/1/1997	8/31/1997	12B972180536	1	65.50		7/1/1999	6/30/2000
1997	8	8/1/1997	8/31/1997	12E021300421	1	4201.00		8/1/1999	7/31/2000
1997	8	8/1/1997	8/31/1997	12E972320121	1	23853.50		9/1/1999	8/31/2000
1997	8	8/1/1997	8/31/1997	12E972932387	1	520.47		10/1/1999	9/30/2000
1997	8	8/1/1997	8/31/1997	12E973090764	1	968.81		11/1/1999	10/31/2000
1997	8	8/1/1997	8/31/1997	12E973090783	1	1289.51		12/1/1999	11/30/2000
1997	9	9/1/1997	9/30/1997	12E002511138	1	204229.16		1/1/2000	12/31/2000
1997	9	9/1/1997	9/30/1997	12E972800161	1	2088.00		2/1/2000	1/31/2001
1997	9	9/1/1997	9/30/1997	12E973090814	1	587.33		3/1/2000	2/28/2001
1997	9	9/1/1997	9/30/1997	12E973090831	1	423.62		4/1/2000	3/31/2001
1997	9	9/1/1997	9/30/1997	12E973090838	1	6980.08		5/1/2000	4/30/2001
1997	9	9/1/1997	9/30/1997	12F972750710	1	16304.71		6/1/2000	5/31/2001
1997	9	9/1/1997	9/30/1997	12G972760011	1	5191.77		7/1/2000	6/30/2001
1997	10	10/1/1997	10/31/1997	12E973142322	1	11209.43		8/1/2000	7/31/2001
1997	10	10/1/1997	10/31/1997	12E980211315	1	14317.28		9/1/2000	8/31/2001
1997	10	10/1/1997	10/31/1997	12E980361346	1	3369.00		10/1/2000	9/30/2001
1997	10	10/1/1997	10/31/1997	12E981281290	1	64351.58		11/1/2000	10/31/2001
1997	10	10/1/1997	10/31/1997	12F972790441	1	638.50		12/1/2000	11/30/2001
1997	11	11/1/1997	11/30/1997	12B973352421	1	665.64		1/1/2001	12/31/2001
1997	11	11/1/1997	11/30/1997	12D973300140	1	244108.23		2/1/2001	1/31/2002
1997	11	11/1/1997	11/30/1997	12G980541683	1	24877.28		3/1/2001	2/28/2002
1997	12	12/1/1997	12/31/1997	12B980052622	1	4487.50		4/1/2001	3/31/2002
1997	12	12/1/1997	12/31/1997	12E973520161	1	10880.64		5/1/2001	4/30/2002
1997	12	12/1/1997	12/31/1997	12E980230176	1	15000.00		6/1/2001	5/31/2002
1997	12	12/1/1997	12/31/1997	12E980230207	1	1060.00		7/1/2001	6/30/2002
	1	1/1/1998	1/31/1998		0	0.00		8/1/2001	7/31/2002
1998	2	2/1/1998	2/28/1998	12B980431727	1	550.00		9/1/2001	8/31/2002
1998	2	2/1/1998	2/28/1998	12E003211772	1	7574.54		10/1/2001	9/30/2002
1998	2	2/1/1998	2/28/1998	12E980640947	1	11111.39		11/1/2001	10/31/2002
1998	2	2/1/1998	2/28/1998	12E981051511	1	7638.00		12/1/2001	11/30/2002
1998	2	2/1/1998	2/28/1998	12E981341401	1	121.51		1/1/2002	12/31/2002
1998	3	3/1/1998	3/31/1998	12B981041973	1	59663.64		2/1/2002	1/31/2003
1998	3	3/1/1998	3/31/1998	12E980892661	1	6415.98		3/1/2002	2/28/2003
1998	3	3/1/1998	3/31/1998	12E981051631	1	2853.62		4/1/2002	3/31/2003
1998	3	3/1/1998	3/31/1998	12E981201183	1	567.00		5/1/2002	4/30/2003
1998	3	3/1/1998	3/31/1998	12G981180083	1	30177.60		6/1/2002	5/31/2003
1998	3	3/1/1998	3/31/1998	12G981331831	1	1570.00		7/1/2002	6/30/2003
1998	3	3/1/1998	3/31/1998	12G981550058	1	10462.80		8/1/2002	7/31/2003

<colgroup><col span="2"><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[GR00007]

Please check your count column - it may be text, as indicated by the left align of your example.
In an unused cell put =Type(F2), if you get a 2 that cell is text.
If that's so, one way to resolve is to put in an unused column on the first row of data put =Value(F#) where # is that row, then copy down, copy and paste over the same rows in F.
For large sheets, letting Excel change the format by selecting the range and using the down arrow at the exclamation point takes forever.