The syntax for the formula COUNT in Word

[Richard]

I would like to count all the Y's in a column of a table. It concerns the
second column and i want the answer to be a round number without decimals.
I already found: { =COUNT(b:b) \# "0" }
How do indicate in the formula that only the Y's in the column have to be
counted?
What is the syntax for that?
Thanks!

 

[Doug Robbins - Word MVP]

It cannot be done with a simple Equal Field construction. You would need to
use a macro that iterated through the cells checking if each one contained a
Y and incrementing a counter if the result was positive and then enter the
final value of the counter in the cell in which you want the count to be
displayed

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP