By using this site you agree to the use of cookies for analytics, personalized content and ads. Learn more

Try Microsoft Edge A fast and secure browser that's designed for Windows 10 Get started

Microsoft Microsoft
Office
    • No results
    0  items in shopping cart
    Sign in
    Office Buy Office 365
    Office
      • Plans & pricing
      • For households
      • For individuals
      • Office Online
      • Plans & pricing
      • Small business
      • Enterprise
      • See all business
      • For students & teachers
      • For schools
      • Word
      • Excel
      • PowerPoint
      • Outlook
      • Access
      • Microsoft Teams
      • OneDrive for Business
      • Project
      • SharePoint
      • Skype for Business
      • Visio
      • See all Office products
    • Customer stories
    • Frequently asked questions
    • Install Office
    • IT Pro resources
    • Security & compliance
    • System requirements
    TemplatesSupport Buy Office 365
    Support
    • Apps
      • Access
      • Excel
      • OneDrive
      • OneNote
      • Outlook
      • PowerPoint
      • SharePoint
      • Skype for Business
      • Visio
      • Word
    • Install
    • Account
    • Training
    • Admin

    Video: SUMIF function in Excel

    Applies To: Excel 2010 More... Less
    Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

    See how to use the SUMIF function to sum the values in a range that meet criteria you specify.

    Facebook LinkedIn Email
    Expand your skills
    Explore training
    Get new features first
    Join Office Insiders

    Was this information helpful?

    Thank you for your feedback!

    Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

    Contact Support
    ×
    Learn
    • Windows
    • Office
    • Skype
    • Outlook
    • OneDrive
    • MSN
    Devices
    • Microsoft Surface
    • Xbox
    • PC & laptops
    • Microsoft Lumia
    • Microsoft Band
    Microsoft Store
    • View account
    • Order tracking
    • Returns
    • Recycling
    • Commercial Warranties
    • Order & Shipping
    Downloads
    • Download Centre
    • Windows downloads
    • Windows 10 apps
    • Office apps
    • Microsoft Lumia apps
    • Internet Explorer
    Values
    • Microsoft in education
    • Privacy at Microsoft
    Company
    • Careers
    • About Microsoft
    • Company news
    • Site map
    English (United Kingdom)
    • Contact Us
    • Privacy & Cookies
    • Terms of use & sale
    • Trademarks
    • Office accessibility
    • Legal
    • © Microsoft 2017