JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
i have a row of data containing 8 digit numbers and i want to count the number of 10,20 or 30 at the 5th and 6th digit
is there an easy way to do this?
Example: data in column A
10053001
24224002
14432001
54419030
44301002
10223001
55677501
not sure what to put in for the criteria but formula from above data should output a value of 4
i could do it by creating another formula =MID(A2,5,2) but would prefer not to as theres lots of data
any help appreciated
i have a row of data containing 8 digit numbers and i want to count the number of 10,20 or 30 at the 5th and 6th digit
is there an easy way to do this?
Example: data in column A
10053001
24224002
14432001
54419030
44301002
10223001
55677501
not sure what to put in for the criteria but formula from above data should output a value of 4
Code:
=COUNTIFS($A:$A,??)
i could do it by creating another formula =MID(A2,5,2) but would prefer not to as theres lots of data
any help appreciated