Dear all,

I’m trying to create an “template” to my workload in excel but I’m stuck in same “multiple conditions and operations”
In detail:
I have 3 types of projects: NP,CD,2i with different workload/month


NP = New Project TGA → ABVC = 7 month / 1Manager + 1Info


ABVC → ABPT2 = 5 month / 1Manager
ABPT2 → ... = 2 month / 0,5Manager

CD = derivate body TGA → ABVC = 7 month / 0,6Manager + 0,6Info
ABVC → ABPT2 = 6 month / 0,6Manager + 0,6Info

2i = second Indus TGA → ABVC = 7 month / 0,5Manager + 0,5Info
ABVC → ABPT2 = 7 month / 0,25Manager + 0,25Info




for every month I want to calculate the projects sum in each month for Managers and Infos. 2 persons works on a project (for ex. between TGA and ABVC for 7 month works 1Manager + 1Info ....)






I also tried to create a function for this in VBA but doesn't work as I want...( can you help me with this one?

thanks in advance!

Attached Files

charge test.xlsx (23.1 KB, 17 views)