 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Totaling 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. 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 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. > Try something like this: > [quoted text clipped - 14 lines] > > "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 > 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? [quoted text clipped - 18 lines] > > > "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 > Let's back up a step.... > [quoted text clipped - 28 lines] > > > > "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  SignatureRegards, Peo Sjoblom > 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 [quoted text clipped - 37 lines] >> > > > "x"s by row and column. I am new at this and need a step by step >> > > > instruction. Thanks. 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. > 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 [quoted text clipped - 48 lines] > >> > > > "x"s by row and column. I am new at this and need a step by step > >> > > > instruction. Thanks. 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 SignatureRegards, Peo Sjoblom > 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 [quoted text clipped - 58 lines] >> >> > > > step >> >> > > > instruction. Thanks. 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. > 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 [quoted text clipped - 64 lines] > >> >> > > > 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, > Let's back up a step.... > [quoted text clipped - 28 lines] > > > > "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 > 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 [quoted text clipped - 32 lines] > > > > > "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 >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. > Not sure what "by row and column" means but to count the x's in a range of > cells. [quoted text clipped - 10 lines] > >"x"s by row and column. I am new at this and need a step by step > >instruction. Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.