Breadcrumbs

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

sumif1.png

Step 2 : Then type in the SUMIFS Formula in the area you would like to display the outcome:

sumif2.png

Step 3 : Type in the complete SUMIFS formula for a cell as shown below:

sumif3.png

Step 4 : Excellentable will generate the outcome when hitting enter. 

sumif4.png

 

There were errors rendering macro:

  • An unknown error occurred.