Formula for Total Column

EJMcDonald

In our estimating sheet I'd like to have a locked formula that for parent rows it shows the sum of the children and on non-parent rows it shows the product of quantity*rate.

I'd like it to be one formula so that it can be locked on the column. Right now I have separate formula's that from time to time will be messed up and creates an issue.

Is this possible?

Leibel S

Something like this:

=IF(COUNT(CHILDREN()) > 0, SUM(CHILDREN()), Quantity@row * Rate@row)

Kleerfyre

If you have your formulas, just place them in the needed cells, then right click on the column header and select lock column. It will then lock the column from being able to be changed.