+ Reply to Thread
Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 16 to 30 of 31

count if not 0s

  1. #16
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    super ! but my clenn i would like F4 to look only on E4(counter) just the counter and check how many times a number diid not apeared and counts like the formula youmade!
    Last edited by louis128; 01-12-2019 at 06:16 AM.

  2. #17
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    or maybe can we create for the counter E4 a range? so is like first step is the range B:B ,then the counter E4, then to create a 'new range' for the counter and F4 to look on 'new range'?
    Last edited by louis128; 01-12-2019 at 06:18 AM.

  3. #18
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    can we create an range of counter? i mean whick shows the counting results of E4 , please!

  4. #19
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: count if not 0s

    No. I do not understand what you want.
    Glenn



  5. #20
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    dear clenn ,I want in Q4 amodification of the formula like you made, to count a number did not apeared!, so it means alternative it counting how many zero apeared, yes? i attached you the exact example, sorry if i was not clear before!

  6. #21
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    I want in Q4 amodification of the formula like you made, to count how many times a number(any number except 0) did not apeared in P2.

  7. #22
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: count if not 0s

    I do not understand your English. Please show me your expected results for two or three example sets of data.

  8. #23
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    thanks! i will try to explain better. so atthe last work book i attached, i have a formula which counts the event 1 2 in O:O, so if 1 2 comes counts 1, if 1 2 1 2 1 2 comes counts 3 but if any other event comes like 222,or 112222 counts 0 zero.what i need is a 'history of counts.



    please see attachement example 2. thanks!

  9. #24
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    i attached another example of 'history'.

  10. #25
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    please have a look to that example!!thanks

  11. #26
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    is like

    extract the results of the array formula(or counter)!!!

  12. #27
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: count if not 0s

    Your examples do not help. Post one file, not 3. Remove EVERYTHING except the relevant data. Your sheets are full of rows of numbers and I do not have the patience, the time, or the enthusiasm to figure it all out. You MUST tell me what results you expect to see. There is no point in repeating the same words, as they do not make sense to me.

  13. #28
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    please check that one

  14. #29
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: count if not 0s

    and last you put the extract results where was like i show here!thanks alot

  15. #30
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,346

    Re: count if not 0s

    Mr. Louis, as per your last so many example, all necessary result's, solved out. This is a new one, kindly closed this thread, & post new one.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ Reply to Thread
Page 2 of 3 FirstFirst 1 2 3 LastLast

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