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
Bookmarks