percentage calculation of cells based on second column data

Hi,

I'm in a partnership project where our funding calculates an 'overheads' payment at a flat rate of 7% of expenses. I have a full project budget including all partners expenses, with a column saying which business a budget line is linked to. To track the variation between the budget and actual spend I'm trying to get the budget line for each partners overheads to calculate automatically based on the actual spend in their budget lines. I have included a made up example, with a manually calculated outcome at the bottom. I've colour coded the cells to try to make it simple to visualise what I'm trying to get a % of.

Any help would be greatly appreciated, I keep trying do do one more step from a sumif start but just can't work it out.

Try, C11=SUMIFS(C$2:C$10,$B$2:$B$10,$B11)*7%, copy across.