Reply
 
Thread Tools Display Modes
  #1   Report Post  
JakeW
 
Posts: n/a
Default What is the formular that will count IF a specific word is found,.

What is the formular that will count IF a specific word is found in a word
table column, such as 'YES'?
  #2   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

COUNTIF, but it's in Excel, not Word.

--
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.

"JakeW" wrote in message
...
What is the formular that will count IF a specific word is found in a word
table column, such as 'YES'?


  #3   Report Post  
Greg
 
Posts: n/a
Default

Jake,

Maybe you could use a macro something like:

Dim oTable As Table
Dim oRng As Range
Dim oCell As Cell
Dim pContent As String
Dim i As Integer
Dim rowLast As Long


Set oTable = ActiveDocument.Tables(1)
rowLast = oTable.Rows.Count
i = 0
Set oRng = oTable.Range
For Each oCell In oRng.Columns(1).Cells
pContent = oCell.Range.Text
pContent = Left(pContent, Len(pContent) - 2)
If pContent = "Yes" Then
i = i + 1
End If
Next
ActiveDocument.Tables(1).Cell(rowLast, 1).Range.Text = i
End Sub

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
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
need to count word total for 1200 documents Donald C. McNeilly Formatting Long Documents 2 January 15th 05 01:54 PM
Ideas for macro to add row for count and percentage Bradley C. Hammerstrom Tables 8 January 6th 05 10:38 AM
INCLUDEPICTURE --> able to include all images in a specific direct ScottAtMU Mailmerge 3 January 5th 05 05:13 AM
Change Line Count to not count blank lines Carol Microsoft Word Help 4 November 27th 04 01:46 PM


All times are GMT +1. The time now is 09:45 PM.

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"