Hope you can help.

I'm trying to count up the number of cells in a row that have data in. This is for the number of arrows that hit the target.

For example, all 12 arrows hit the target and so all of my twelve cells are filled with data. As I'm already using "X" to score as 10, the following formula works great: =COUNTA(B25:G25)+COUNTA(I25:N25)

However, I also want to use the letter "M" to denote a miss. So, say I had two "X"s, two "M"s and another eight numbers, the total hit count would be 10 (10 hits out of a possible 12). I'm struggling with adding that to the formula so that any instance of "M" is not counted in the total number of hits.

Many thanks if you can help,

Justy