Dec 16, 2021 at 12:21 PM
- Registration date
- Sunday September 12, 2010
- Last seen
- September 12, 2022
So you basically want to count cells that contain data.
When the D.O numbers are located in range B2 to B101 and only 10 cells contain data, then the result of the formula above will be 10.
Is this what you are looking for?