Adds numbers within a range that meet multiple specified criteria.
Sample Usage
SUMIFS(Cost:Cost; Quantity:Quantity; >25; [Task Name]:[Task Name]; "Task A")
Syntax
SUMIFS(

range

criterion_range1

criterion1
 [
]
 criterion_range2
 criterion2
 ...
 range—The group of cells to sum, assuming they meet all criteria.
 criterion_range1—The group of cells to be evaluated by the criterion.
 criterion1—The condition that defines which numbers to add; for example: 15, "Hello World!", or >25.
 —[optional]
 criterion_range2
 criterion2
 ...
Additional ranges and criteria to have evaluated.
Usage Notes
 For criterion, acceptable operators include: = (equal to), <> (not equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to).
 All evaluated criteria must be true for the number in the corresponding range to be added.
Examples
This example references the following sheet information:
Item  Quantity  Cost  Warehouse 

Shirt  26  20,00  A 
Pants  24  50,00  A 
Socks  10  10,00  A 
Shirt  18  25,00  B 
Pants  16  75,00  B 
Socks  46  15,00  B 
Given the table above, here are some examples of using SUMIFS in a sheet:
Formula  Description  Result 

=SUMIFS(Quantity:Quantity; Cost:Cost; >30;Warehouse:Warehouse;"A")  Sums the Quantity of any item from Warehouse "A" with a Cost over 30,00  24 
=SUMIFS(Quantity:Quantity; Quantity:Quantity; >10; Cost:Cost;<20)  Sums the Quantity of anything over 10 with a Cost under 20,00  46 
=SUMIFS(Cost:Cost; Quantity:Quantity; >15; Warehouse:Warehouse; "A"; Item:Item; OR(@cell = "Shirt"; @cell = "Socks"))  Sums the Cost of anything with a Quantity over 15 from Warehouse "A" where the Item is either "Shirt" or "Socks" NOTE: This formula also uses the OR Function and @cell parameter. 
20,00 