I want to count the number of text fields in a
column which are labeled R1, R2, R3.
I can count them seperately =COUNTIF(A20:A35,"R1")
however, I want to count R1s, R2s and R3s total.
I have tried =COUNTIF(A20:A35,"R1:R3") but I do not
get a correct answer.
Is there another way to phrase this?
Thanks
Bookmarks