Counting Quantities of Numbers

Jason Tarpinian

I am trying to build a column to count the # of times a predecessor appears in the predecessor column. The below formula has almost gotten me there, but it is also counting predecessor cells that include 1, but not exactly 1 (like 12, 21, 100, etc...)

=COUNTIF(Predecessors:Predecessors, FIND(1, @cell) > 0)

Is there any way to search for exactly 1, or perhaps another way to get my answer I'm not thinking of?

 

Thank you!

L_123

=COUNTIF(Predecessors:Predecessors, 1)

 

will return all cells in predecessors that are = 1

 

Andrée Starå

L@123,

That was my thought as well, but it only works if the predecessor 1 is the first of the predecessors.

Best,

Andrée

L_123

=COUNT(COLLECT(Predecessors:Predecessors, Predecessors:Predecessors, 1))

 

guess that is why you test before you answer. the above seems to work

Andrée Starå

I got a Deja Vu moment!

I've been down this road before! I don't remember how/if we solved it. 

Unfortunately, it didn't work (not for me anyway)

Best,

Andrée

 

L_123

https://app.smartsheet.com/b/publish?EQBCT=ae7455ff40b841feb1c60f24449ad4af

Andrée Starå

I've added another predecessor, and it won't work with multiple if it's not the first one.

Best,

Andrée

L_123

Yeah if there are multiple predecessors on a single row a helper column is needed.