Ok - I did that - but then what. What do I do to get the total? I have tried
using the
auto sum function key - they same way I would add up a column of numbers -
but it
comes back "=SUM()" in a different cell.

"Gord Dibben" wrote:

Not sure what "by row and column" means but to count the x's in a range of
cells.

=COUNTIF(range,"x") entered in a cell outside the range.

i.e.

range is A1:F23 enter the formula in G1


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 09:56:08 -0700, Randi
wrote:

I have several cells with an "x" in them. I am trying to get a total of the
"x"s by row and column. I am new at this and need a step by step
instruction. Thanks.