Skip to main content

SUMIFS

Definition

This function adds the cell in a range using multiple criteria.

Syntax

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

 

Error.

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

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.