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 basket
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
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.

Additional resources
Install Install Install Install
Admin Admin
Training Training
Facebook Twitter Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

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