Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Richard Richard is offline
external usenet poster
 
Posts: 150
Default 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   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!



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Syntax Error in Footer kfrancis Page Layout 4 December 6th 06 05:00 PM
Formula - Syntax Error ArchieDog via OfficeKB.com Tables 2 June 8th 06 06:59 AM
If Formula syntax error BigPig Tables 5 February 3rd 06 05:52 PM
Word's word count feature should be able to count sentences also Connor Microsoft Word Help 31 November 15th 05 07:03 PM
A word count that appears next to the page count Wordy88 Microsoft Word Help 1 June 24th 05 12:30 AM


All times are GMT +1. The time now is 05:22 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"