SUMIFS Function in Excel

Question

What is the SUMIFS function in Excel?

Answer

The SUMIFS function adds up the data in selected cells when specific criteria are met in two or more ranges of data.  

The SUMIFS function works like the AND function in that it only sums the data if the criterion for each range is true.  
The syntax for the SUMIFS function is: =SUMIFS ( Sum_range, Criteria_range1, Criteria1, Criteria_range2, Criteria2, ...)

  • Sum_range - the range of cells to be added.
  • Criteria_range - the range of cells the function is to search.
  • Criteria - determines whether a cell in the Sum_range is to be counted or not. 

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request

Details

Article ID: 7932
Created
Thu 12/29/22 12:30 PM
Modified
Fri 11/3/23 3:56 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.