Formula using both an IF and SUM(CHILDREN()) parts

Bradley Pallister

Hello people

 

I would like the cell in [Total]5 to show the sum of all its children, but only if the [Qty of Tasks]5 cell is empty.  If [Qty of Tasks]5 is not empty, then I would like [Total]5 to show =SUM(Tender5 + Variation5)

 

I have tried =IF([Qty of Tasks]5, "", =SUM(CHILDREN()), (Tender5 + Variation5) * [Qty of Tasks]5) but this comes up with an error.

 

I would appreciate any pointers to resolve this,

 

Many thanks

 

Dietrich Koch

Something like this?

 

=IF([Qty of Tasks]5 > 0, SUM(CHILDREN(Tender5)) + SUM(CHILDREN(Variations5)))