Sign in to join the conversation:
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.
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
Hi I am tryingbuild a new Stock Control system using barcode reader on my mobile feeding into the sheets. The issue I have is adding the items up on one sheet and adding to items to another sheet to work out stock levels. I am tried using the barcode or ref no as the Lookup.
I have three columns I'm dealing with, SALARY IRA(check mark) IRA amount if the ira checkmark is checked, take SALARY *0.035 in the ira amount column
I am currently working on a construction project where I am tracking Request for Information (RFI) for our subcontractors. I can get up to 30 RFIs a day. My question is what is the best way to track how many I process daily? Is there a Countif formula or a DataMesh process that works best?
