Totaling a column or row of "x" s


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

Advertisements

G

Guest

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
 
G

Guest

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

Guest

Let's back up a step....

Describe your data layout and what you want to do.

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

XL2002, WinXP
 
G

Gord Dibben

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
 
G

Guest

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
 
Ad

Advertisements

G

Guest

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,
 
G

Guest

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

Peo Sjoblom

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
 
G

Guest

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
 
G

Guest

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

Advertisements

P

Peo Sjoblom

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
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top