This is the third part of a 4-part series about counting in Excel. This short tutorial demonstrates how to count the number of rows in a table that match a given criteria.

Excel - Count Rows in a Table that Match a Criteria

The screenshot above is taken from an Excel file that contains a list of tutorials on this website. Some of the tutorials have accompanying videos. Column D contains a “Y” if there is an accompanying tutorial.

In the video below I explain how to count the number of tutorials that contain a video and how to ensure that if the Table range is increased and more videos are added, the count automatically updates.

In the final tutorial of the 4-part series, I explain a different way to achieve the same result without adding the extra “helper” column.