DARREN TROFIMCZUK
  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact

SUMIF & SUMIFS

SUMIF and SUMIFS formulae are formed by combining SUM and IF Functions. 

​The SUM function has the capability to add items, and SUMIF function extends the capabilities of SUM function by giving you the choice to SUM only those items that meet a particular criteria.

SUMIF Function:

=SUMIF(range, criteria [, sum_range])
  • ‘range’ refers to the cells that you want to be evaluated by the ‘criteria’.
  • ‘criteria’ refers to the condition that specifies which items are to be added. ‘criteria’ can be a number, expression or a text string.
  • ‘sum_range’ is an optional argument, it specifies the cells to be added. If ‘sum_range’ argument is omitted then SUMIF treats ‘range’ as ‘sum_range’.
SUMIFS Function:

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
  • ‘sum_range’ specifies the cells that are to be added based on the given conditions. It is a required field.
  • ‘criteria_range1’ specifies the first range where the first criteria is to be evaluated.
  • ‘criteria1’ specifies the condition that is to be evaluated in the ‘criteria_range1’.
  • ‘criteria_range2’, ‘criteria2’ specifies the other ranges and their respective conditions. It is an optional argument. SUMIFS supports a total of 127 range criteria pairs.
Support Link: ​http://www.exceltrick.com/formulas_macros/excel-sumif-and-sumifs/

Practice Task File

sumif-exercises_student.xlsx
File Size: 9 kb
File Type: xlsx
Download File

1) Sum of refrigerator items
2) Sum of washing machine items
3) Sum of items transported by truck 4
4) Sum of items transported by trucks
Note: I have already setup a table for you to place the answers on the spreadsheet file

  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact