Need formula to count starred items from a parent row.

Eric Shin

I'm looking to count starred children from a parent row.  

I'm sure there's an easy way to do it by doing a: COUNTIF(CHILDREN(....

Any help is appreciated.  

Andrée Starå

Hi Eric,

Try this.

=COUNTIF(CHILDREN(Stars@row); 1)    

The same version but with the below changes for your and others convenience.  

=COUNTIF(CHILDREN(Stars@row), 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting