Tool to calculate total of hours based in a complex criteria

[Jose J Lopez]

Hi experts – I need a help here if you think this is possible.
I have an excel with 2 tabs –
In Tab1(Applications) –
In this Tab – the key fields are: App Type (App1, App2 or App3), Tasks Id and Complexity
The 3 Key fields combined will produce a unique key to find the total of hours in Tab2(Tasks per hours).

Tab2(Tasks per hours): In this tab – a kind of template per Tasks Id, Application Type and complexity.

I provided an example in the same XLS attached in the tab (Explanation) Where I draw with more details the calculus required.

Can I resolve this with formula or I have to use VB?

Any help would be much appreciated.

Thanks in advance and best regards.

JJ

 

[Nebu]

Hi:
What is the logic of identifying the multiple Task Ids? I guess it more than a combination of Complexity and App Type . Is Team a factor in deciding the Task ids?

Thanks

 

[Jose J Lopez]

Tasks Ids will be added manually. Team is not a factor in deciding the task ids.

 

[Jake Collins]

Dear Jose

It seems you wanted a formula for column G in the Applications Sheet. See the attached.

I've had to make some small changes such as using a comma before and after each task ID. I also created 3 named ranges TaskTime,TaskList and AppType