I Have some data which is based on the rough example below. In row 5 is a random series of manually entered "x"s and "c"s with thr rest being blank. I would like, if possible to have a formula that counts to total amount of "x"s and "c"s in row 5. So in this case the result would be 6.
Regards
a b c d e f g h i j k l m n o p
1
2
3
4
5 x x c c x x
6
7
Regards
a b c d e f g h i j k l m n o p
1
2
3
4
5 x x c c x x
6
7