+ Reply to Thread
Results 1 to 6 of 6

How to COUNT numbers of items?

  1. #1
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    How to COUNT numbers of items?

    I have used function to track numbers of NOT EMPTY FILEDS.

    How to count this with this function as I have sample string of random numbers like:
    09-400-000004

    Numbers will be added on the right.

    It shows me still value 0 although I have NOT EMPTY value like: 09-400-000004

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to COUNT numbers of items?

    09-400-000004 is not a value as far as excel is concerned, rather it is some text.

    try using COUNTA instead of COUNT
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    Re: How to COUNT numbers of items?

    Is this COUNT of text or STRING of numbers, text...

  4. #4
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251

    Re: How to COUNT numbers of items?

    =counta(1:1) counts the number of cells in a range that are not empty.

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to COUNT numbers of items?

    Beware however that COUNTA counts Nulls as non-blank... if your values are the result of formulae and are always text you may find using COUNTIF(A:A,"*?") safer method.

  6. #6
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    Re: How to COUNT numbers of items?

    What will do COUNTIF(A:A,"*?") in steps?

+ 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