I am trying to write a formula in excel.

Sheet A col A = identifier
Sheet B col A = identifier
Sheet B col B = year (1,2,3 etc.)
Shett B col C = salary

On Sheet A col B

I want to get the sum of salary in Sheet B col C that matches the identifier in Sheet A col A, but only for years marked as 1.


Can anyone help?