count zeros

[rival36]

Dear Sir,
I want following result with the data.
Condition is: Count zeroes that occurred previously in the column after occurrence of an integer number if an integer number is present in adjacent column
thanks in advance.

data zero count

2.4 0
0
0
3 2
0
0
0
5 3
4 0
0
0
0
5 3
9 0
0 0
11 1
0
0
55 2
0
5 1
0 0
0 0
4 2
7 0
8 0
0
0
5 2
0
5 1
0
0
4 2
5 0
4 0
1 0
0
0
4 2
0
1 1

 

[jtakw]

Hi,

Would this do?

Book3.xlsx
	A	B
1	data	zero count
2	2.4	0
3	0
4	0
5	3	2
6	0
7	0
8	0
9	5	3
10	4	0
11	0
12	0
13	0
14	5	3
15	9	0
16	0
17	11	1
18	0
19	0
20	55	2
21	0
22	5	1
23	0
24	0
25	4	2
Sheet928

Cell Formulas
Range	Formula
B2:B25	B2	=IF(A2>0,COUNTIF(A$2:A2,0)-SUM(B$1:B1),"")

 

[arthurbr]

FYI cross posted at XLForum ( and reported on this board)

 

[jtakw]

Thanks, @arthurbr , it's also cross-posted here:

Count zeroes that occurred previously

Dear Sir, I want following result with the data. Condition is: Count zeroes that occurred previously in the column after occurrence of an integer number if an integer number is present in adjacent column thanks in advance. data zero count 2.4 0 0 0

www.excelforum.com

 

[rival36]

Hi,

Would this do?

Book3.xlsx
	A	B
1	data	zero count
2	2.4	0
3	0
4	0
5	3	2
6	0
7	0
8	0
9	5	3
10	4	0
11	0
12	0
13	0
14	5	3
15	9	0
16	0
17	11	1
18	0
19	0
20	55	2
21	0
22	5	1
23	0
24	0
25	4	2
Sheet928

Cell Formulas
Range	Formula
B2:B25	B2	=IF(A2>0,COUNTIF(A$2:A2,0)-SUM(B$1:B1),"")

Thanks a lot sir... it worked perfectly

 

[jtakw]

You're welcome, thanks for the feedback.