Project budgeting

I'm maintaining a project budget sheet but i am having a problem with a formula i have applied same formula to all columns but last column is not being linked to the total formula bar.

I am using the formula =sum(children()) for all columns, can you assist me in figuring this out

Find more posts tagged with

Formulas

Comments

Shaine Greenwood

Hi Mohammed,

To clarify, do you have a SUM(CHILDREN()) formula in all of your columns, and then a different formula that calculates the grand total from all of your SUM(CHILDREN()) formulas?

If that's the case, you'll need to reference the last column's SUM(CHILDREN()) cell in your grand total formula.