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. 



User does not have sufficient privileges to access this Content
Learn More