Sum multiple column if the header contains certain word

[seeker123]

Hi everyone

I have a very large database like below in every row I want to have the sum of budget,Actual and remaining man hour of all departments.
In other words i want to write a sumif based on header containing specific word.
how can I do that?

Thanks a lot.

[TABLE="class: grid, width: 1510"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD="align: left"]Project[/TD]
[TD="align: left"]Budget Dev[/TD]
[TD="align: left"]Actual Dev[/TD]
[TD="align: left"]Remaining Dev[/TD]
[TD="align: left"]Budget Design[/TD]
[TD="align: left"]Actual Design[/TD]
[TD="align: left"]Remaining Design[/TD]
[TD="align: left"]Budget Design[/TD]
[TD="align: left"]Actual Design[/TD]
[TD="align: left"]Remaining Design[/TD]
[TD="align: left"]…[/TD]
[TD="align: left"]Total Budget[/TD]
[TD="align: left"]Total Actual[/TD]
[TD="align: left"]Total Remaining[/TD]
[/TR]
[TR]
[TD="align: left"]Project1[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD] [/TD]
[TD="align: left"]Some of all budgets[/TD]
[TD="align: left"]Some of all Actuals[/TD]
[TD="align: left"]Some of all Remainings[/TD]
[/TR]
[TR]
[TD="align: left"]Project2[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD] [/TD]
[TD="align: left"]Some of all budgets[/TD]
[TD="align: left"]Some of all Actuals[/TD]
[TD="align: left"]Some of all Remainings[/TD]
[/TR]
[TR]
[TD="align: left"]Project3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]…[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Under the header Total Budget enter and copy down:

=SUMIFS($B2:$J2,$B$1:$J$1,"Budget*")

 

[seeker123]

Under the header Total Budget enter and copy down:

=SUMIFS($B2:$J2,$B$1:$J$1,"Budget*")

Thanks a lot Aladin.it works perfectely.

 

[Aladin Akyurek]

Thanks a lot Aladin.it works perfectely.

You are welcome.