Hi, I have copied an example below in which I want to count how many "1" or "1a" "1b" or "1c" appear in row S - i currently use COUNTIF(marksheet name!S$2:$S251,"1?") but that only counts the cells with a a,b,or c at the end not the whole number cells, hope i'm making sense.
A B C D E F G H I J K L M N O P Q R S
name 1 F 9KN 9A5/En 17/18 BOSCOBEL K Y 92 L 3 8.85 2.8 1A 1 1
name 2 M 9AP 9A3/En 17/18 ATTINGHAM N Y 96 L 4 14.2 4.7 3A 3 2C
name 3 M 9FR 9A3/En 17/18 ATTINGHAM N Y 96 M 5 16.9 5.6 4A 4 2C
name 4 F 9FR 9B4/En 17/18 ATTINGHAM N Y Y 100 L 4 14.6 4.9 3A 3 1B
Solved by X. J. in 13 mins