I need a formula that will allow me to count the number of Xs in a cell....The total Xs should be 5, but when I use the formula, COUNTA(B2:M2) , it counts 3.... I tried COUNTIF(B2:M2,"X") but it also counted only 3....

What formula can I use to count the number of Xs in each cell?

A | B | C | D | E | F | G | H | I | J | K | L | M | |

1 | Shift | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |

2 | 7 AM | XXX | X | X |

<colgroup><col><col><col span="12"></colgroup><tbody>

</tbody>