Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel count enteries

    Excel 2003 I have a column in which some cells have a name the rest are blank. What is the formula for counting the number of cells that have an entry.
    Thanks

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You need the COUNTA function: =COUNTA(F:F) for example.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Apr 2012
    Posts
    240
    Thanks
    3
    Thanked 24 Times in 24 Posts
    For counting words, use this formula =COUNTA(E1:E12). Substitute the range you want to count for E1:E12.

    Doug Mac

  4. #4
    3 Star Lounger
    Join Date
    Apr 2012
    Posts
    240
    Thanks
    3
    Thanked 24 Times in 24 Posts
    Sorry Rory, your reply didn't show up until I posted mine.

    Doug Mac

Posting Permissions

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