In this video, we will see how we can count cells with specific text in Excel - using a simple formula. We will see how we can count cells that contain only the exact words or count cells with specific text as well as other text in the same cell.
Click on Timestamp to jump to the relevant part of the video:
0:00 - Introduction
0:29 - Count Cells with Exact Text Match
1:36 - Count Cells with Text Starting with Specific Word
3:00 - Count Cells with Specific Word anywhere in Text
Click here to subscribe to my channel to get more videos of Excel formula tips and uses:
/ @exceltipsvideos
Check out our Excel Graph Playlist for ideas on creating great-looking charts :
• Excel Graphs