+ Reply to Thread
Results 1 to 3 of 3

How to count total words in a column?

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    How to count total words in a column?

    Hi All,

    I need to determine the total number of words in a column and output the total to a different cell. Each cell will only ever have one word. I can do this with ASAP Utilities, but I need to be able to repeat this automatically as the word list changes. so I need a formula instead. Can someone please show me how to do this? I can find references online for how to count instances of a certain word, or duplicates, but nothing for the total words in a column. Thanks!

    (Example of a list; generally with hundreds of words):
    a
    alone
    also
    an
    and
    any
    anything
    anytime
    as
    beautiful
    .
    .
    .

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to count total words in a column?

    Maybe =COUNTA(A:A)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-31-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to count total words in a column?

    Quote Originally Posted by shg View Post
    Maybe =COUNTA(A:A)
    Well that's just sad that it is so simple. After reading that excel had no native way of doing this (which I thought was crazy) I assumed it would be harder. I did try a few COUNTIFs but no COUNTA. Thank you so much.

+ 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