This is the last part of a 4-part series about counting in Excel. In the previous tutorial, I explained how to count the number of rows in a Table that match a given criteria. However, I did it by adding an extra column into the Table. In this tutorial I show an alternative way…
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 the YouTube URL of each video.
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.