If you have a spreadsheet in which you place an "X" in cells B1:B10 (or rows B1:K1), how do you create a formula to add the # of "X's" in that column/row?
For Example: There is an X in cells, B1, B2, B3, B4, & B5; I want a formula to add the x's which would = 5.
For Example: There is an X in cells, B1, B2, B3, B4, & B5; I want a formula to add the x's which would = 5.
