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?



  • 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
    – Jones
    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

1 Answer 1


Please try this:


(too much caffeine, not enough sleep)

  • That gave the same parse error.
    – Jones
    Commented Jan 31, 2020 at 15:47
  • Answer updated. Commented Feb 2, 2020 at 2:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.