Count function use case

[Davidns]

I have a column wherein the initial rows have a value of zero, followed by a series of non-zero numbers, then followed by more zeroes. Example:
0
0
0
0
0
100
100
100
100
0
0
0
0

What would be the best formula to use to count the number of cells with a value of zero BEFORE the non-zero numbers start? In other words, I do not want to include the zeros after the non zero numbers in the count.
Thanks!

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	0	5
3	0
4	0
5	0
6	0
7	100
8	100
9	100
10	100
11	0
12	0
13	0
14	0
Data

Cell Formulas
Range	Formula
B2	B2	=XMATCH(TRUE,A2:A100>0)-1

 

[Davidns]

Wow, works like a charm. Thank you - would never have come up with that on my own, and frankly, not quite following why it works but glad it does. Much appreciated! (if you have a moment to explain what is going on, I would be very grateful - the "True" part is throwing me)

 

[Fluff]

This part A2:A100>0 returns an array of true/false & the xmatch looks for the 1st TRUE

 

[Davidns]

This part A2:A100>0 returns an array of true/false & the xmatch looks for the 1st TRUE

ahh, got it. Makes perfect sense. I love this board! Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback.