# count if not 0s

1. ## 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!

2. ## 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'?

3. ## Re: count if not 0s

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

4. ## Re: count if not 0s

No. I do not understand what you want.

5. ## 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. ## 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. ## 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. ## 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. ## Re: count if not 0s

i attached another example of 'history'.

10. ## Re: count if not 0s

please have a look to that example!!thanks

11. ## Re: count if not 0s

is like

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

12. ## 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.

14. ## Re: count if not 0s

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

15. ## 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.

Page 2 of 3 First 1 2 3 Last

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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