Best way to sum a table (Array?)

[SUMIF]

Hello

I'm having difficulty in trying to find the best way to sum a table.

Column J should show the total hours for each Job.
Column I will contain a unique list of Jobs.

The green cells will contain job numbers (the job number may be repeated multiple times on different rows & columns).

I've considered using 'SUMIFS' but it feels like a clunky way to do this & might slow the workbook down. Not sure if some sort of Array formula would be better?

Thanks for your help.

Capture.PNG

[Jonmo1]

Try

=SUMIF($B$2:$F$14,$I2,$B$3:$F$15)

[SUMIF]

Wow, so simple i'm embarrassed!

Thank you

[Jonmo1]

You're welcome.