- 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.
Additional ranges and criteria to have evaluated.
- 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.
This example references the following sheet information:
Given the table above, here are some examples of using SUMIFS in a sheet:
|=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.
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.