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.

Project	Budget Dev	Actual Dev	Remaining Dev	Budget Design	Actual Design	Remaining Design	Budget Design	Actual Design	Remaining Design	…	Total Budget	Total Actual	Total Remaining
Project1	20	10	10	30	15	15	40	20	20		Some of all budgets	Some of all Actuals	Some of all Remainings
Project2	50	20	30	60	10	50	20	10	10		Some of all budgets	Some of all Actuals	Some of all Remainings
Project3
…

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[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.