Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
The syntax for the formula COUNT in Word
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! |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Syntax Error in Footer | Page Layout | |||
Formula - Syntax Error | Tables | |||
If Formula syntax error | Tables | |||
Word's word count feature should be able to count sentences also | Microsoft Word Help | |||
A word count that appears next to the page count | Microsoft Word Help |