Sum of child cells divided by the count of filled chilled cells

[msiraj]

Welcome to the Spreadsheet community, @Emmet_Haughian

For your usecase, request you to consider SUBTOTAL formula-function instead of SUM & COUNT functions for calculating averages.

SUBTOTAL function on DESCENDANTCELLS will ignore other SUBTOTAL formula results in hierarchy.

Also reference Project Budget template which has a similar scenario as explained in below post and uses SUBTOTAL function on DESCENDANT CELLS.

Using DESCENDANTCELLS for Subtotals in a Project Budget

A new Project Budget template in the gallery is available that demonstrates the use of the formula SUM(DESCENDANTCELLS()) function to calculate subtotals for hierarchical budget categories. This uses the Indent/Outdent feature in Spreadsheet.com. [image] The Budget column in this worksheet calculates the cost for each task by adding the fixed costs, materials, labor and other costs. To avoid showing a subtotal in this column, it uses the CHILDCELLS function to check whether the row has any ch…