Miscounting in column T
Results 1 to 4 of 4

Thread: Miscounting in column T
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2018
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Miscounting in column T

    Hi. In the linked spreadsheet, please could someone fix the count in column 'T'. It keeps counting one too many.

    Thanks in advance.

    https://1drv.ms/x/s!AtIvkRgReIvwgRbfii9zm52ozImr

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,042
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Miscounting in column T

    No it doesn't.

    You have the value 151 in K3, that plus a non zero value in E3 counts as 2.
    Excel is correct.

    Column K has data that you haven't displayed correctly.
    Change the colour column K's text to red and you'll see there are non zero values in that column.
    Last edited by Special-K99; Jul 11th, 2019 at 10:25 AM.

  3. #3
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,818
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Miscounting in column T

    will fudge with =COUNTIF(E3:Q3,">0")-1
    • Yes I know there are better ways to do it. I just wish I knew them. - 97, 2003, 2007, 2010, 2013, 2016 & 2019
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,566
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Miscounting in column T

    or =SUMPRODUCT(--(F3:Q3>0))

    with data like this:

    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    3
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    294
    294
    1
    4
    0
    146
    148
    149
    0
    151
    0
    0
    0
    0
    0
    0
    743
    743
    4
    5
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    296
    296
    1
    6
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    151
    151
    1
    7
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    151
    151
    1
    8
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    151
    151
    1
    9
    0
    147
    149
    0
    149
    151
    0
    0
    0
    0
    0
    0
    744
    744
    4
    10
    0
    148
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    441
    441
    2
    11
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    295
    295
    1
    12
    0
    149
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    446
    446
    2
    13
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    151
    151
    1
    14
    0
    0
    0
    0
    0
    151
    0
    0
    0
    0
    0
    0
    301
    301
    1
    15
    75
    150
    150
    150
    150
    151
    0
    0
    0
    0
    0
    0
    973
    898
    6
    Last edited by sandy666; Jul 11th, 2019 at 10:41 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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