SUMIFS Combined with DATE Functions

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

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *