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 1st of September to 31st of December, 2019.
The following function is as follows:
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 1st September to 31st December, 2019. So, let’s add “after 1st 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 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.
After the same, we come to the point of criteria 2.
So, the criteria 2 is as follows:
So, the overall formula of the SUMIFS Function becomes:
Now, press enter.
And BAAAMMMM!!! The answer is 131000. This means that the total sales between 1st September 2019 to 31st December, 2019 is 131000.