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. – marikamitsos Jan 31 '20 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 Jan 31 '20 at 15:57
  • Please do share a sheet so as you can be easier helped. – marikamitsos Jan 31 '20 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. – marikamitsos Feb 2 '20 at 0:18

Please try this:


(too much caffeine, not enough sleep)

  • That gave the same parse error. – Jones Jan 31 '20 at 15:47
  • Answer updated. – marikamitsos Feb 2 '20 at 2:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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