Hi

I need help to expand a formula when a new sheet is created in my workbook. Atm i have 2 sheet 1 named overview and 1 named project 1. I am using overview to supervise my projects.

e.g in cell B3:

=SUMIFS('Project 1'!C:C;'Project 1'!A:A;A6)

Now when a new project is created i want to update the forumula to:

=SUMIFS('Project 1'!C:C;'Project 1'!A:A;A6) + SUMIFS('Project 2'!C:C;'Project 1'!A:A;A6)

Can anyone help?

Thanks in advance

Br

Martin