SUMIF Function in Excel Tutorial

In this step-by-step tutorial, learn how to use the SUMIF Function in Microsoft Excel. With sumif, you can sum cells that meet a certain criteria. Along with SUMIF, we also look at how to use the SUMIFS function, which allows you to sum based on multiple criteria.

• Additional resources
  • Sample workbook to follow along
• Timestamps
  • 0:00 Introduction
  • 0:44 SUMIF formula
  • 2:59 SUMIF with wildcards
  • 4:15 SUMIFS – one criteria
  • 5:41 SUMIFS – multiple criteria
  • 10:08 Other functions
  • 10:37 Wrap up