Sumif Function in Excel


Sumif and Sumifs

Video on Sumif and Sumifs

MY videos are all created on Camtasia.
TechSmith Camtasia Click Here

  • Sumif is a very handy tool to total a variety of data by criteria.
  • Similar to "if statements" you set a criteria.
  • We have student marks, using an "if statement we have catgorized the results.
  • We would like to total the course fee by results
  • We will total the course fees for those who failed the course
    We will use the function dialog box by clicking on the

    fx

    and typing in sumif in the search for funtion box
  • The Range is the cells that you are testing the criteria
  • Criteria is what you are test for, in our case "fail"
  • Sum_range is the cells that contain the values that you want to total
  • From the Function Argument box you can see the result is 6000
  • Now, we would like to total the fees for student for failed but are able to do a w rewrite.
      We will use the function dialog box by clicking on the

      fx

      and typing in sumifs in the search for funtion box
    • The dialog box has a different order, the first is the Sum_range
    • Sum_range is the cells that contain the values that you want to total
    • Next; Criteria_range1, when the criteria range is select, you will be required to enter a criteria for that range.
    • You will be give to select a another criteria range and criteria
    • Sum_range will be the fee values
    • The first critera, will be pass or fail we will select "fail"
    • The second criteria will be "rewrite"
    • From the Funtion Argument box you can see the result is 3750