Repair formula that show winning percentage of a variable?

Q4:Q60 is not 21 rows? Perhaps you have other values inside that range that you are not looking at?

Try changing the ranges to just what you need, because yes, those 2 0's are more than likely being included, although that should reduce the %, not increase it.

7/23 = 30.4%

I just re-ran your calc from post 1.

Your formula
=COUNTIF(sheet1!Q4:Q60;">0")/COUNTIF(sheet1!Q4:Q60;"<>0")
is completely ignoring the 0 (ties?), so you are only counting a max of 19 entries, not 21
7/19 = 36.8%

Try this instead...
=COUNTIF(sheet1!Q4:Q60;">0")/COUNTa(sheet1!Q4:Q60)
Although, I would still prefer you used the actyal ranges.

What formula did you use?
Is there a formula in those "blank" cells - ie where do the results come from?
Will there always be 21 entries?
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

1. You have 8 >0 not 7
2. excluding blanks/zeros, you have a total of 19, not 21
3. 8/19 = 42.1%
=COUNTIF(F4:F24,">0")/COUNTIF(F4:F24,"<>0")

OR if you want to exclude zero from ONLY numerator and NOT the denominator (which I believe is incorrect)...
8/21 = 38.1%

There are zeroes in two of the cells (G13 and G23) conditionally formatted not to appear. Remove them and you will get the result you require.

No, you have 8, not 7

A4 385
A5 800
A6 5
A7 520
A14 390
A16 75
A18 95
A20 220

Change the formula in G4 to this and drag down:

=IF(F4="","",IFERROR(F4*E4/5,0))

Then use this:

=COUNTIF(G4:G60,">"&0)/COUNT(G4:G60)

There are 8 in green - Ford is correct:

Excel 2016 (Windows) 32 bit

	E	F	G
3	Quantity		TOTAL $
4	1	385	77
5	1	800	160
6	1	5	1
7	1	520	104
8	1	-90	-18
9	1	-90	-18
10	1	-5	-1
11	1	-135	-27
12	1	-20	-4
13	1	0	0
14	1	390	78
15	1	-60	-12
16	1	75	15
17	1	-85	-17
18	1	95	19
19	1	-80	-16
20	1	220	44
21	1	-75	-15
22	1	-150	-30
23	1	0	0
24	1	-105	-21

Sheet: Sheet1

My sheet is altered , i am so sorry about that

For me:

F16 = 75 AND G16 =-15 instead of 15

so just please consider G15 AS -15

See post #17.

Excel 2016 (Windows) 32 bit

	E	F	G	H	I	J	K	L	M	N	O
3	Quantity		TOTAL $
4	1	385	77
5	1	800	160					Porcentage of winning numbers:			33.33%
6	1	5	1
7	1	520	104
8	1	-90	-18
9	1	-90	-18
10	1	-5	-1
11	1	-135	-27
12	1	-20	-4
13	1	0	0
14	1	390	78
15	1	-60	-12
16	1	-75	-15
17	1	-85	-17
18	1	95	19
19	1	-80	-16
20	1	220	44
21	1	-75	-15
22	1	-150	-30
23	1	0	0
24	1	-105	-21

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	G
4	=IF(F4="","",IFERROR(F4*E4/5,0))
5	=COUNTIF(G4:G60,">"&0)/COUNT(G4:G60)

Sheet: Sheet1

Please see attached.

You need to drag copy the formula in G4 right down to G60.

No problem.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

As long as you got where you wanted to be