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. 

	A	B	C	D
1	State	Quantity Sold	Product	Salesperson
2	Alabama	5	Apples	Sarah
3	Alaska	4	Apples	Tom
4	Arizona	15	Artichokes	Sarah
5	Arkansas	3	Artichokes	Sarah
6	California	22	Bananas	Tom
7	Colorado	12	Bananas	Sarah
8	Connecticut	10	Apples	Tom
9	Delaware	33	Apples	Tom
10	Florida	6	Carrots	Sarah
11	Georgia	14	Carrots	Sarah
12	Hawaii	9	Artichokes	Tom
13	Idaho	7	Apples	Tom
14
15		63

	E	F
1	Population	Total Area in mi2
2	4833722	52,420 (135,767)
3	735132	665,384 (1,723,337)
4	6626624	113,990 (295,233)
5	2959373	53,179 (137,733)
6	38332521	163,695 (423,968)
7	5268367	104,094 (269,602)
8	3596080	5,543 (14,356)
9	925749	2,489 (6,446)
10	19552860	65,758 (170,312)
11	9992167	59,425 (153,910)
12	1404054	10,932 (28,314)
13	1612136	83,569 (216,443)
14
15