Multiply across columns, then sum children

Clinical Research Industry User

I would like to use the sum children formula, however the calculation includes other columns before it can sum. 

The month column contains number of units, while the cost of each unit is in another column.  The sum for the month = #units * cost per unit.  Can the children formula be used so that the formula doesn't have to be edited every time a new row is added?

Paul Newcome

I would suggest a helper column where you do the multiplication, then SUM that column using something along the lines of

 

=SUM(CHILDREN([Helper Column]@row))

Andrée Starå

Hi,

Probably! I'd be happy to take a look!

Can you share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

L_123

We can play sum number games with this one (Haha).

 

=avg(children([Mar-2019]@row))*avg(children([Unit/Hour Cost]@row))*count(Children([Unit/Hour Cost]@row))