Hi
This looks like it will work =SUMIF($C$1:$C$16;$A18;$B$1:$B$16)
I put it in B18 and copied it to B33.

The only issue is that the text in columns A18:A33 and C1:C16 need to be identical, I think this also includes spaces at the end of words.


E.g. the A column had "Research and Development" where as in the C column it was "research & development", but copy and paste will readily solve that problem.

Regards.