Excel > Functions

SUMIFS Function

The Excel SUMIFS function is similar to the SUMIF function. It adds up the values from a given range that meets multiple criteria.

The syntax for the SUMIFS function is:

=SUMIFS(sum_range, criteria_range1, criteria1, ...)




The range of cells containing the values you want to add


The range of cells containing the records you want to check against the criteria


The criteria to determine whether the value is added or not

The example below shows the SUMIFS function being used to sum the order amounts by the company Carpet World.

Adding specific records using the SUMIFS function

Follow us on

Facebook  Twitter  You Tube 

Other Mathematical Functions

Excel 2010 Superhero Course