Totaling a column or row of "x" s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Let's back up a step....

Describe your data layout and what you want to do.

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

XL2002, WinXP
 
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
 
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
 
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,
 
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.
 
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
 
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
 
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.
 
Do as follows, select the cell(s), do format>cells>number 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
 
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.
 
Back
Top