Count values

Question

Hello,

I would like help with this file

I would like to count the number of lines between each "wash" (column A).

So I created a column B with a formula where a 0 appears when there is a "Wash" and a 1 when there is something else

The goal is to count the 1s between each 0

For example between line 6 and 83, there are 78 values

Is there a formula that exists to do this?

Thank you for your help

Emma

Untitled 6.jmp

Dan_Obermiller · Accepted Answer

This formula counts them as you go. The last one would be the total number. Would this work?

txnelson · Accepted Answer

Here is a formula that works without having to create column B

If( Row() == 1,
	thecount = 0,
	If( :A == "Wash",
		:Lines Between = thecount;
		thecount = 0;
	,
		thecount++;
		:Lines Between = thecount;
	)
)

See attached data table