Home

ShowMe Excel - COUNTIF and Number Selector

Jimmy Wynen - June 16, 2021

In this video, I'll show you how to build a tool that counts rows of data that have exceeded a certain number, and how many have not.
In this lesson:

  • Naming cells and cell referencing
  • Using greater than and less than symbols in formulas
  • Data validation

In the example, we're using BFA result data and counting the number of people who have completed a certain number of pushups against those that haven't. We then look at this as a percentage.
Download the workbook below to follow along.

This is really just scratching the surface of what can be done with Excel, for more be sure to enrol in the WithYouWithMe Data pipeline.

If you want to break into the tech industry then sign up to our platform and begin your training today.

Join our community

We have a Discord server where you’ll be able to chat with your instructors and cohort. Stay active in your learning!
Join discord