View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default The syntax for the formula COUNT in Word

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

"Richard" wrote in message
news
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!