You can read more about it here( or get VBA code): https://www.excelhow.net/how-to-count...
This Excel video tutorial, we'll explore two methods to count cells not equal to a specific value. We'll start with a formula-based approach using the COUNTIF function, followed by a VBA method for more advanced users.
Time Stamps
00:00:19 Method 1: Count Cells Not Equal to a Specific Value Using Formula
00:01:57 Method 2: Count Cells Not Equal to a Specific Value Using VBA
#########
Learn Microsoft Excel Online Free: https://excelhow.net/
#########