Kingchaos64
New Member
- Joined
- Jan 15, 2021
- Messages
- 46
- Office Version
- 365
- Platform
- Windows
I have a formula of =COUNTIF(E5:OV5,"*-*")
I would like this formula to count all the cells in row 5 that have a dash in them. The cells that have a dashes look like this 00-00-00. To make data entry easier I put a custom formula in the columns and used 00-00-00 as the sample.
Which works great, it makes it super fast to enter the set of numbers without having to put in the dash.
The problem is the COUNTIF formula doesn't recognize the numbers as having dashes so it doesn't count them
Is there a work around to this?
I would like this formula to count all the cells in row 5 that have a dash in them. The cells that have a dashes look like this 00-00-00. To make data entry easier I put a custom formula in the columns and used 00-00-00 as the sample.
Which works great, it makes it super fast to enter the set of numbers without having to put in the dash.
The problem is the COUNTIF formula doesn't recognize the numbers as having dashes so it doesn't count them
Is there a work around to this?