I have used =SUMIFS(E1:E29,A1:A29, 121200, E1:E29,A1:A29, 122400) and all I get is 0.
Column A Column E
120010 0.00
121100 63,509.12
121200 1,183.00
121400 2,997.62
121500 3,692.56
121800 81,891.06
121900 3,877.44
122100 3,500.00
122200 240.00
122400 12,887.00
122600 1,200.00
122700 41,207.46
122800 0.00
124700 55.00
125000 0.00
125120 373.00
125200 49,800.00
125300 9,529.45
125600 877.50
125700 51,173.09
125710 14,775.81
125900 417.00
126100 12,000.00
126400 5,342.52
126800 50,319.60
127300 109,170.36
127400 9,159.79
127500 4,533.58
127800 220,332.00