Can the x be in A9:A28 only or do you mean that you have can have x in all
of those columns and you want the count for each column in row 29 of each
column? If so put this in A29


=COUNTIF(A9:A28,"x")

after you entered the formula, select A29 again, move the cursor to the
lower right corner of A29 and when it changes from a thick cross to a thin,
left click the mouse, then hold and drag across to N29 then release the
mouse button


--
Regards,

Peo Sjoblom


"Randi" wrote in message
...
Column A - Rows 9-28 have several questions that participants answer by
marking an X in Columns B-N, rows 9-28. I want a total of all the Xs
to print on Line 29. Also if it makes a difference I am working in Excel
2000.
Thanks



"Ron Coderre" wrote:

Let's back up a step....

Describe your data layout and what you want to do.

***********
Regards,
Ron

XL2002, WinXP


"Randi" wrote:

I must be doing something wrong - I put that formula in the cell where
I want
the total to print - right? Then what do I use the auto sum function
key?
If so, that's not working. Thanks.

"Ron Coderre" wrote:

Try something like this:

Count of x's in Col_C
=COUNTIF(C:C,"x")

Count of x's in Row_4
=COUNTIF(4:4,"x")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"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.