I am looking to create a count formula that counts only the Children and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This simple formula, =COUNTIF(CHILDREN(), 0) outputs the number of Children in the Parent cell, but leaves a "0" in each Child cell.
This is a very large sheet and so I need the formula to run throughout. Essentially the parent row would be blank and the first child row would be one, then two, three, etc.
Any help would be greatly appreciated.
Tamara