Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel bug in COUNTA (97)

    Kieran is there supposed to be an attachment for us to look at? <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel bug in COUNTA (97)

    You seem to have lost the attachment. If you go to Preview you have to reselect the file attach before posting.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel bug in COUNTA (97)

    I have recently changed jobs and am trying to get my head around the acronyms used.

    I have therefore created a list of them (abbreviated list attached)

    The list works fine, however it seems that the COUNTA function does not.

    As you will see the ranges B2 and C2 count the numbers of acroynms and descriptions in the list.
    The B2 count is fine, however the C2 count is understated by twice the number of blank entries.

    COUNTIF(range,"") does return the correct figure as does the 'instant' count function in the information bar at the base of the applcation.

    Can anyone enlighten me about why Excel can't count using COUNTA?

    TIA.

    Sorry about the lost attachment - maybe I wil have better luck this time
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel bug in COUNTA (97)

    Kieran

    Sorry the COUNTA function is performing properly.

    The named range ‘Acronym_description’ is described as:
    =OFFSET('Acronym List'!$C$7,0,0,COUNTA('Acronym List'!$C$7:$C$403),1)

    The argument ‘COUNTA('Acronym List'!$C$7:$C$403)’ returns the value 8, which is correct, but when used as the height argument to the offset function, the range returned is c7:c14. Then the function =COUNTA(c7:C14) returning 6 is correct.

    Replacing the concent of cell C2 with: =COUNTA($C7:$c403)&" Described so far"
    produces the desired results.

    Good luck,
    Bob_D

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel bug in COUNTA (97)

    Thanks Bob.

    It seems obvious now that it is expained to me, however I don't think that I would have seen the light without your advice.

    I will update the named range definition as it could cause the lookup function at the top of the sheet to produce bad results too.

    Thanks again.

Posting Permissions

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