Welcome to Excel Jet Consult. In this tutorial, we will learn how to combine SUMIFS with DATE functions to return Qtr 1 Total Sales. Let’s get started
In cell H1, execute the formula: =SUMIFS(Total,Order_Date,”>=”&DATE(2015,1,1),Order_Date,”<=”&DATE(2015,3,31))
We can see from the formula above that we wrapped the DATE formula inside SUMIFS
To verify, we will filter the data set to show Order Date from Jan 1st 2015 to March 31st 2015.
Absolutely correct as seen in the Status Bar and Cell H1