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

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

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.

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

The following function is as follows:

**=SUMIFS(**

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

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).

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

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

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

**“>”&I3** will be our criteria 1.

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

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

So, the criteria 2 is as follows:

**“<”&I4**

So, the overall formula of the SUMIFS Function becomes:

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

Now, press **enter**.

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