282595_en-US

liliconcom

Count values

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

 

 

OtherRe: Count valuesThank you !Re: Count values

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

Re: Count values

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