This video shows how to Search through Cells and count the cells Containing certain String using VBA Excel Programming. This will count the number of occurrences. To see code, look at my response to the video.

Handy Excel Resources
https://amzn.to/3gFx7s1 Excel Formulas & Functions For Dummies 5th Edition
https://amzn.to/3sYnuH6 Microsoft Excel 2019 VBA and Macros
https://amzn.to/2PqXhU0 MICROSOFT EXCEL VBA AND MACROS FOR BEGINNERS:
https://amzn.to/3xtsLtM Microsoft Excel VBA Programming for the Absolute Beginner
https://amzn.to/3xwkEg0 Excel 2019 Bible
https://amzn.to/3aJEHxW EXCEL 2020 FOR BEGINNERS

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.