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.

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

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