Formula help

Copper Contributor

Hi, I am trying to create a formula to help track consultant assigned, used, and remaining hours for a roll up of projects. my primary sheet (see attached example) is will be a "project intake form" that ideally will have one project per row each row will contain project information including assigned consultant(s) along with their assigned hrs, used hrs, and available hrs. I could use the sumifs function if each person would remain in a specific column but that is not always the case, so I need for the formula to look at a range of columns and if it returns the consultant name in one of the columns report a sum of hrs for that consultant as a whole and then do a total count of projects. I have attached a sample of data that I would be looking at. 

0 Replies