Summing according to conditions

Hi,

In the attached file I would like to create formulae in cells B6:B8, highlighted in yellow, to sum the values in B2:F2, according to whether the code in B3:F3 has "seniority" of 1, 2 or 3 as indicated in columns H and I.

Can someone please suggest a formula to achieve this.

Thanks!

Hi Andrew- Try this ARRAY FORMULA. Paste in B6, press CTRL+SHIFT+ENTER to confirm, then drag down:
=SUM($B$2:$F$2*(IF($I$2:$I$8 =A6,$H$2:$H$8)=$B$3:$F$3))

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Excellent, thank you!

Happy to help, thank you for the rep! If appropriate, please mark your thread as SOLVED (Thread Tools, up top). Thanks again- Lee