Adds numbers within a range when all given conditions in their respective ranges are met.
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 
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in realtime.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.