+ Reply to Thread
Results 1 to 5 of 5

count function not working, keeps displaying 0

  1. #1
    DaveB
    Guest

    RE: count function not working, keeps displaying 0

    The COUNT(...) function only counts numeric values. To count all values use
    COUNTA(...), so your formula would be:

    =COUNTA(H1:H5)
    --
    Regards,

    Dave


    "dnm" wrote:

    > One more question. Every time I try to use the count function it keeps
    > displaying 0 even though I have values. For example:
    >
    > H
    > 1 REC 21
    > 2 REC 24
    > 3 REC 19
    > 4 REC 22
    > 5 REC 21
    >
    > Which I would then use the formula =COUNT(H1:H5) which should display 5, but
    > it shows 0.
    >
    > Does anyone know why this could be happening?


  2. #2
    dnm
    Guest

    RE: count function not working, keeps displaying 0

    Awesome! Thanks

    "DaveB" wrote:

    > The COUNT(...) function only counts numeric values. To count all values use
    > COUNTA(...), so your formula would be:
    >
    > =COUNTA(H1:H5)
    > --
    > Regards,
    >
    > Dave
    >
    >
    > "dnm" wrote:
    >
    > > One more question. Every time I try to use the count function it keeps
    > > displaying 0 even though I have values. For example:
    > >
    > > H
    > > 1 REC 21
    > > 2 REC 24
    > > 3 REC 19
    > > 4 REC 22
    > > 5 REC 21
    > >
    > > Which I would then use the formula =COUNT(H1:H5) which should display 5, but
    > > it shows 0.
    > >
    > > Does anyone know why this could be happening?


  3. #3
    dnm
    Guest

    count function not working, keeps displaying 0

    One more question. Every time I try to use the count function it keeps
    displaying 0 even though I have values. For example:

    H
    1 REC 21
    2 REC 24
    3 REC 19
    4 REC 22
    5 REC 21

    Which I would then use the formula =COUNT(H1:H5) which should display 5, but
    it shows 0.

    Does anyone know why this could be happening?

  4. #4
    DaveB
    Guest

    RE: count function not working, keeps displaying 0

    The COUNT(...) function only counts numeric values. To count all values use
    COUNTA(...), so your formula would be:

    =COUNTA(H1:H5)
    --
    Regards,

    Dave


    "dnm" wrote:

    > One more question. Every time I try to use the count function it keeps
    > displaying 0 even though I have values. For example:
    >
    > H
    > 1 REC 21
    > 2 REC 24
    > 3 REC 19
    > 4 REC 22
    > 5 REC 21
    >
    > Which I would then use the formula =COUNT(H1:H5) which should display 5, but
    > it shows 0.
    >
    > Does anyone know why this could be happening?


  5. #5
    dnm
    Guest

    RE: count function not working, keeps displaying 0

    Awesome! Thanks

    "DaveB" wrote:

    > The COUNT(...) function only counts numeric values. To count all values use
    > COUNTA(...), so your formula would be:
    >
    > =COUNTA(H1:H5)
    > --
    > Regards,
    >
    > Dave
    >
    >
    > "dnm" wrote:
    >
    > > One more question. Every time I try to use the count function it keeps
    > > displaying 0 even though I have values. For example:
    > >
    > > H
    > > 1 REC 21
    > > 2 REC 24
    > > 3 REC 19
    > > 4 REC 22
    > > 5 REC 21
    > >
    > > Which I would then use the formula =COUNT(H1:H5) which should display 5, but
    > > it shows 0.
    > >
    > > Does anyone know why this could be happening?


+ 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