# SUMIFS Function

Adds numbers within a range that meet multiple specified criteria.
Sample Usage
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.
• criterion_range2
• criterion2
• ...
—[optional]
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