this is the situation when we add a particular data as per the specifications.

To understand the same, let’s take an example:

SUMIFS Formula

As you can observe in the image above, we have product, its colour, sales, and date.

Previously: How to calculate Percentage Discount in excel?

Now, let’s say we want the sum total of sales between 01st September 2019 to 31st December 2019.

SUMIFS Formula

Now, we will use the SUMIFS Function to calculate the sales between 1st of September to 31st of December, 2019.

The following function is as follows:

=SUMIFS(

The function requires sum range, criteria range 1, criteria 1, and so on…

SUMIFS Formula

Now as we want to calculate the sales, so our sum range will be the Sales. So, we will select the same (cell D3:D11).

SUMIFS Formula

Then we come to criteria range 1. The criteria range 1 is the Date.

SUMIFS Formula

Then we come to the aspect of criteria 1. So, as we need to calculate the total sales between 1st September to 31st December, 2019. So, let’s add “after 1st September, 2019”.

To do the same, this is what we will input:

SUMIFS Formula

“>”&I3 will be our criteria 1.

SUMIFS Formula

Then we will come to criteria range 2. The criteria range 2 will remain the Date only, as we need the sales between 1st September to 31st December, so to add the 31st December in the formula, we will again select the Date in the criteria range 2.

SUMIFS Formula

After the same, we come to the point of criteria 2.

SUMIFS Formula

So, the criteria 2 is as follows:

“<”&I4

SUMIFS Formula

So, the overall formula of the SUMIFS Function becomes:

=SUMIFS(D3:D11,E3:E11,”>”&I3,E3:E11,”<”&I4)

SUMIFS Formula

Now, press enter.

SUMIFS Formula

And BAAAMMMM!!! The answer is 131000. This means that the total sales between 1st September 2019 to 31st December, 2019 is 131000.