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)
https://docs.google.com/spreadsheets/d/1tjRIAjh9jUkfNraRKOPqi4_rjH4ulVxWf0JzwotJy1M/edit?usp=sharing
=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