Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

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.

Totaling a column or row of "x" s
 

That is exactly what I want to do - but whenI put the formula in there -
shouldn't it give me a total whenI hit enter? The formula just stays there.
"Peo Sjoblom" wrote:

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.

Totaling a column or row of "x" s
 

Do as follows, select the cell(s), do formatcellsnumber and select General
formatting, press F2 and then enter. Looks like you have text format, there
is never necessary to format as text unless you need to type in things with
leading zeros for export or type in things like serial or credit card number
with more digits than 15


--
Regards,

Peo Sjoblom



"Randi" wrote in message
...
That is exactly what I want to do - but whenI put the formula in there -
shouldn't it give me a total whenI hit enter? The formula just stays
there.
"Peo Sjoblom" wrote:

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.

Totaling a column or row of "x" s
 

Thanks - I tried the formula in a similar spreadsheet I have and it worked.
I tried what you have below for the one I've been working in and it doesn't
help. Thanks for your help - I will just use the one that works.
"Peo Sjoblom" wrote:

Do as follows, select the cell(s), do formatcellsnumber and select General
formatting, press F2 and then enter. Looks like you have text format, there
is never necessary to format as text unless you need to type in things with
leading zeros for export or type in things like serial or credit card number
with more digits than 15


--
Regards,

Peo Sjoblom



"Randi" wrote in message
...
That is exactly what I want to do - but whenI put the formula in there -
shouldn't it give me a total whenI hit enter? The formula just stays
there.
"Peo Sjoblom" wrote:

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.