I'd recommend perhaps using arrays formulas such as SUMPRODUCT, SUMIFS, COUNTIFS, etc to always pull all records and simply narrow the field down by date criteria.

Are you able to attach a sample worksheet with your data formatting, so we can see which application or adjustment may be most relevant/helpful?