- Understand the Difference between COUNTIF and SUMIF
- Read Excel’s Documentation on How to Use COUNTIF and SUMIF
- Identify Cells or Criteria to be Counted or Summed
- Select the Range of Cells to be Examined
- Enter the Formula into the Target Cell
- Change the Results as Desired