# Google Sheets Sumif formula error when criterion is date range

I am trying to sum data from the Jones tab if its between the dates in C1 & B10. But it returns an formula parse error. I assume I am using some syntax incorrectly, any suggestions?

=sumifs(Jones!D20:25,Jones!B20:B25,"<="C1,Jones!B20:B25,">="B10)

• Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Commented Jan 31, 2020 at 15:41
• I also tried this: =sumifs(Jones!D\$2:D\$211,Jones!B\$2:B\$211,"=<\$C\$1",Jones!B\$2:B\$211,"=>\$B\$10") which returned 0 instead of 8 Commented Jan 31, 2020 at 15:57
• Please do share a sheet so as you can be easier helped. Commented Jan 31, 2020 at 16:07
• I just had a look at your sheet. Cells in the formula you ask for (`=sumifs(Jones!D20:25,Jones!B20:B25,"<="C1,Jones!B20:B25,">="B10)`) are just empty. Could you please check the cells you are interested in and update your formula with the correct ones? And do let us know after by answering to this comment. It is the only way to know about it. Commented Feb 2, 2020 at 0:18

``````=sumifs(Jones!D20:D25,Jones!B20:B25,"=<C1",Jones!B20:B25,">=B10")