#1
|
|||
|
|||
HELP - SUMIF more than 3 conditions + operations in the sum
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! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help sumif with variable for VBA | jingo | Excel Programming | 4 | 01-23-2014 11:02 AM |
Average if and sumif | jennamae | Excel | 4 | 01-17-2014 05:10 AM |
Help! 'SUMIF' Formulas | dave1372 | Excel | 2 | 09-08-2011 07:05 AM |
SUMIF Formula question | jcaswell | Excel | 3 | 05-22-2011 02:52 AM |
Multiple criteria in SUMIF? | pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |