Hello All,
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?
<colgroup><col><col><col span="12"></colgroup><tbody>
</tbody>
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>