This function adds the cell in a range using multiple criteria.
array- specifies the cells that are to be added based on the given condition.
- conditionarray - specifies the first range where the first condition is to be evaluated.
- subrange - specifies the condition that is to be evaluated in the "conditionarray".
Step 1 : In order to use the SUMIFS formula, start with your edited Excellentable
Step 2 : Then type in the SUMIFS Formula in the area you would like to display the outcome:
Step 3 : Type in the complete SUMIFS formula for a cell as shown below:
Step 4 : Excellentable will generate the outcome when hitting enter.