Collections     Essentials     Microsoft Office 2016: Intermediate Excel

---

In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.

---

---

Objectives

Excel 2016: Using Conditional Formulas Inserting a conditional sum formula Inserting a conditional message formula Performing complex conditional formulas Creating multiple conditions Using IF & OR in conditional formulas Using conditional formulas to count up value occurrences Translating data in your worksheet Using reference positions in conditional formulas Keeping your table up to date with conditional formulas