ibmy
Board Regular
- Joined
- Mar 4, 2020
- Messages
- 136
- Office Version
- 2016
- Platform
- Windows
Hi, 
My interest value is "0" (zero) in repetitive and I would like to know total number of its occurrence.
I need 3 formula. Formula 2 is basically from output of Formula 1 and Formula 3 is s single formula that can straight count.
Thanks.

My interest value is "0" (zero) in repetitive and I would like to know total number of its occurrence.
I need 3 formula. Formula 2 is basically from output of Formula 1 and Formula 3 is s single formula that can straight count.
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | data | Formula 1 | Formula 2 | Formula 3 | ||||||
2 | 0 | 1 | ||||||||
3 | 0.2 | 1 | 1 | |||||||
4 | 1 | |||||||||
5 | 0 | 1 | ||||||||
6 | 0 | 1 | ||||||||
7 | 0 | 1 | ||||||||
8 | -0.9 | 3 | 3 | |||||||
9 | 1.2 | |||||||||
10 | -3.2 | |||||||||
11 | 0 | 1 | ||||||||
12 | 0.1 | 1 | 1 | |||||||
13 | 0 | 1 | ||||||||
14 | 0 | 1 | ||||||||
15 | -0.1 | 2 | 2 | |||||||
16 | 0 | 1 | ||||||||
17 | 1 | 1 | ||||||||
18 | ||||||||||
Sheet3 |