Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-1310592%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1310592%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20create%20a%20formula%20to%20help%20track%20consultant%20assigned%2C%20used%2C%20and%20remaining%20hours%20for%20a%20roll%20up%20of%20projects.%20my%20primary%20sheet%20(see%20attached%20example)%20is%20will%20be%20a%20%22project%20intake%20form%22%20that%20ideally%20will%20have%20one%20project%20per%20row%20each%20row%20will%20contain%20project%20information%20including%20assigned%20consultant(s)%20along%20with%20their%20assigned%20hrs%2C%20used%20hrs%2C%20and%20available%20hrs.%20I%20could%20use%20the%20sumifs%20function%20if%20each%20person%20would%20remain%20in%20a%20specific%20column%20but%20that%20is%20not%20always%20the%20case%2C%20so%20I%20need%20for%20the%20formula%20to%20look%20at%20a%20range%20of%20columns%20and%20if%20it%20returns%20the%20consultant%20name%20in%20one%20of%20the%20columns%20report%20a%20sum%20of%20hrs%20for%20that%20consultant%20as%20a%20whole%20and%20then%20do%20a%20total%20count%20of%20projects.%20I%20have%20attached%20a%20sample%20of%20data%20that%20I%20would%20be%20looking%20at.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1310592%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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