If your list starts in cell A1 and the Department you are "summing" is in E1
using your data as an example you could use =SUMPRODUCT((A1:A9=E1)*(B1:B9))
in say cell F1 which gives 13. Change cell E1 to read 132 and the answer in
F1 is 9.

Hope this helps