IF Statement assistance for evaluating Char string to add Values

[gator528]

Any assistance with this request is truly appreciated.

I am trying to do my own 'resource utilization' sheet for multiple projects in a portfolio using Excel.

I have column A with names: Smith, Andrew, Taylor, Mary, etc.

I have Columns B - N ( which contains the resource % of hours required for the respective months - Jan - Dec.)

Each resource is listed across multiple projects.

Problem: I need to summarize by resource the total hours for each month that they are allocated to then 'highlight' which ones will have issues with over-allocation to projects? Hence I need to aggregate 'all' of the hours per resource in a summary across each month.

I want to be able to 'select' from Column A where the name like '%Taylor%' for each project below. Once found I want to go across and 'add' up all of the expected hours for that person. I then want to summarize all of the hours for '%Taylor%' so that I have a complete summary review for all of the project work and to determine where '%Taylor%' is over-allocated?

Any assistance is appreciated.

[pmalen]

Can you provide an example worksheet? So we can see a clearer picture of what you want?

Thanks