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

About This Class

7ad9a3be

This class will demonstrate six examples of the mega useful COUNTIF function. This function has helped me so much over the years in accomplishing many an Excel task.

I hope this class will help you understand the versatility of the function and how it could help you even beyond its typical use.

The lessons will include using COUNTIF to count values between two dates, prevent duplicate entries, uniquely rank items and also compare lists.

This function can be combined with others to extend its power. An example in this class shows it used with VLOOKUP to return the last match in a list.

So dive into the class. I will see you there.

Get in touch if you need any assistance.