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.