Now we will apply the SUMIFS formula to find the total sales. Our task is calculating the total value of sales, whether it is through direct or online. We will now consider a small table with data of sales and revenue through online and direct as below. If we are using OR logic, then we can perform SUM calculation for dual criteria.įor using OR logic, we should use SUMIFS instead of SUMIF because SUMIF can perform with single criteria, but SUMIFS can perform on multiple criteria as per our requirement. Normally SUMIF will work on the logic, AND hence that is the reason where ever the criteria match, it will perform the addition and return the results.īy using normal SUMIF, we will be able to perform SUM operation for only single criteria. Make sure you are using the commas and a double column for criteria otherwise, the formula will throw an error. Similarly, we can find the sales of Y and Z also. The sum of sales of X across all the three companies is 11166.
0 kommentar(er)
