Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Spreadsheet Basics

Well done!

You have completed Spreadsheet Basics!

Sign up for Treehouse Back to Library

The SUMIF Function

2:41 with Michael Watson

SUMIF is a very handy function. It combines the SUM and IF functions to sum up values based on conditions you specify.

Example Files

  • you can continue to use the spreadsheet from the last video, or
  • open a copy of this spreadsheet to catch up to this video

Reference

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    It combines sum and if functions to sum up values based on conditions you specify. 0:00
    Maybe a manager is looking at the spreadsheet of all their salespeople and 0:02
    wants to know how many of them sold more than $1 0:06
    million worth of business last month. 0:08
    She could use the SUMIF function to calculate that. 0:11
    Let's revisit the retail interview spreadsheet to do a SUMIF calculation. 0:14
    >> We're back in our retail transaction spreadsheet example now and we're trying 0:19
    to answer the question, what is the total value of all the jeans that we sold? 0:24
    We could use sorts and filters to figure this out or we can use the SUMIF function. 0:29

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up