The COUNTIF Function – A Mega Useful Excel Function

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Lessons (32m)
    • 1. Introduction

      3:00
    • 2. Using Cell Values with COUNTIF

      4:58
    • 3. Count Values Between Two Dates

      2:58
    • 4. Prevent Duplicates in a Range

      4:12
    • 5. Compare Two Lists to Identify Missing Items

      4:24
    • 6. VLOOKUP for the Last Match in a List

      7:40
    • 7. Uniquely Rank Items

      5:05

Project Description

Open the countif-project.xlsx file.

1. Create a Conditional Formatting rule for range A2:A6 on the Colours 1 sheet. This rule will format the colours that do not occur on the Colours 2 sheet.

2. On the Prevent Duplicates sheet, use the COUNTIF function in a Data Validation rule on column A to prevent duplicate entries.

Resources(1)

Student Projects