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.

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.

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.

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.

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.

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.

Column A - rows 9-28 have questions that people respond to by marking an
X in the cell of Columns B-N (lines 9-28). If makes a difference - am
working in Excel 2000,

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

I've kinda' tried out what you actually said your worksheet looks like, seems
to me your question has been answered, but to put it in step-by-step
try this:
in B29 put (just copy and paste)
=COUNTIF(B9:B28,"x")

in C29 put
=COUNTIF(C9:C28,"x") etc...

but you can autofill by just putting the first formula in C29, then move
your cursor to the right bottom of THAT cell ( see black highlighted corner)
click - hold and drag it until you get to Column N
HTH


"Randi" wrote:

Column A - rows 9-28 have questions that people respond to by marking an
X in the cell of Columns B-N (lines 9-28). If makes a difference - am
working in Excel 2000,

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

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.

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.