Forum Discussion
Trying to gather hours from different workpackages
Hello Guys, I am trying to solve the following Problem: I have different kind of projects named OVR,ITS and DIG. Inside these projects i am working of different packages like 2.1, 5.1, 3.3, 1, 3.5 ...
SUMIF accepts wildcards, so you could do this:
=SUMIF(C:C, A:A, "OVR*")
or
=SUMIF(C:C, A:A, "OVR-2.1*")
=SUMIF(C:C, A:A, "OVR*")
or
=SUMIF(C:C, A:A, "OVR-2.1*")
- That gives me 0 as summed up Hours.
I Do understand it correct, that A:A is my comment with the OVR and that my C:C are my hours?Use JKPieterse 's formula but with SUMIFS instead of SUMIF
HansVogelaar
Hey thank you.
I tried to sort it not via OVR but via the workpackages like 2.1.
so now it would be =SUMIFS( J7:J16; I7:I16;"2.1*"), but it gives me 0 as an outcome. Anything i have to do different with numbers ?
