Hi everyone,

I need some help with a formula, im not sure if it's possible to do the following, and I am even having trouble explaining it in words;

1. Check a range of cells in a column for a value - if it finds this value anywhere in the column then,
2. Check a cell in a second column [for each previous successful find] for a value - if it finds this value then,
3. Take a value in a third column [multiple values if we have multiple 'hits'] and add these up.

The columns im checking information for are basically Employee, Stage of Project, Cost.

So I want to check the entire table and find the total cost for each employee for each project state.

Any input on this would be greatly appreciated.

Thanks

Alberto