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
|
|||
|
|||
Count Formula in a Table
I have a table where the user inserts the letter X in the
cell to indicate if they have an item on hand. I want to insert a formula so that it counts the number of X's the user has entered. For example, Table example: 1. X TV 2. VCR 3. X DVD COUNT = 2 For the record, I can't use the checkbox control for this excercise. |
#2
|
|||
|
|||
Count Formula in a Table
Hi Saron,
You can't count non-numerics with a table formula in Word. You could do it with a bunch of IF statements, provided all of the cells had their contents bookmarked. For more information, see: http://www.wopr.com/cgi-bin/w3t/show...&Number=365442 Cheers "Saron" wrote in message ... I have a table where the user inserts the letter X in the cell to indicate if they have an item on hand. I want to insert a formula so that it counts the number of X's the user has entered. For example, Table example: 1. X TV 2. VCR 3. X DVD COUNT = 2 For the record, I can't use the checkbox control for this excercise. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004 |
#3
|
|||
|
|||
Count Formula in a Table
This is, however, very easy to do in Excel, so the best solution might be to
embed an Excel sheet in the Word doc. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "macropod" wrote in message ... Hi Saron, You can't count non-numerics with a table formula in Word. You could do it with a bunch of IF statements, provided all of the cells had their contents bookmarked. For more information, see: http://www.wopr.com/cgi-bin/w3t/show...&Number=365442 Cheers "Saron" wrote in message ... I have a table where the user inserts the letter X in the cell to indicate if they have an item on hand. I want to insert a formula so that it counts the number of X's the user has entered. For example, Table example: 1. X TV 2. VCR 3. X DVD COUNT = 2 For the record, I can't use the checkbox control for this excercise. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004 |
Thread Tools | |
Display Modes | |
|
|