If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word 2000 Table Count Contents Of Cells
I have word table and in each cell I have the user insert the letter "X"
to indicate 'yes'. I want to keep track of the number of "x"'s the user places in each cell. For example, TV X DVD VCR X TOTAL 2 How would I accomplish this? --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Word 2000 Table Count Contents Of Cells
It would be a lot easier to count cells with Xs if they were in a
separate column. Otherwise, a macro would have to test every cell to see whether the last two characters were a space followed by an X (so as to to pick up any entries ending in X (eg BOX) Easier still would be to use a column in which the user entered a 1 or a 0, the just sum the column with a Word field (eg press Ctrl-F9 and type =SUM(ABOVE) between the braces, then press F9 to update). This would avoid the need for a macro and could be automated if you set it up as a series of formfields with the 'calculate on exit' property set. Word fields can't count text entries. Cheers --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|