SUMIF Function in Excel

Question

What is the SUMIF function in Excel? 

Answer

The SUMIF function is used to add up the values in cells in a selected range that meet certain criteria.  The syntax for the SUMIF function is: = SUMIF (Range, Criteria, Sum Range)

  • Range - the group of cells the function is to search.
  • Criteria - determines whether the cell is to be counted or not.
  • Sum Range - the data range that is summed if the first range meets the specified criteria. If this range is omitted, the first range is summed instead. 

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 Print Article

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.