+ Reply to Thread
Results 1 to 2 of 2

Count Specific Text Values in a Word Table Formula

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Dallas, TX
    MS-Off Ver
    2010
    Posts
    1

    Count Specific Text Values in a Word Table Formula

    Hello,

    I am having an issue with creating a Word 2010 formula that provides a count of the specific values found in the column of a table. The basic details are below.

    The column may contain the following distinct values:
    Off Duty
    Limited Duty
    Returned to Regular Work

    I would like to create individual formulas (in three different cells) that count the number of times that each string occurs. For instance, the example output would be:

    Off Duty: 5
    Limited Duty: 7
    Returned to Regular Work: 12

    I understand how to handle this in Excel using the COUNTIF function. Unfortunately, I don't believe that Word has the same function.

    I'm certain that it is easier than I'm making it...I appreciate any and all suggestions!

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Count Specific Text Values in a Word Table Formula

    Word has no in-built functions for counting text values in a table - only fields for numeric values. You could embed an Excel worksheet in your document and have access to all of Excel's functionality.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1