I've spent the last hour unable to get through a relatively straight forward problem. I would like to sum a range of cells, however it cannot be a fixed formula as the rows and cells will change regularly.

I have tried combining INDEX, MATCH and SUMIF but have not been able to get anywhere. I've built a sample spreadsheet for what I'm trying to solve for, the image is attached below.

Ideally, I need to sum the values in C assuming that it matches with F2.

Help would greatly be appreciated.

`Employee B`

but in the criteria you have just the`B`

is this the way it is in the actual data or do they match? – Scott Craner Jun 26 at 18:38