Trying to gather hours from different workpackages

Question

Hello Guys,I am trying to solve the following Problem:I have different kind of projects named&nbsp;OVR,ITS&nbsp;and&nbsp;DIG. Inside these projects i am working of different packages like&nbsp;2.1, 5.1, 3.3, 1, 3.5 etc. .&nbsp;And then you can also see the&nbsp;hours&nbsp;beeing display in the next column.I now want to gather the hours for each Package (e.g. 2.1) and sort them to the projects.My Idea was to use: =SUMIF(C:C, A:A, "OVR") but it did not work and gave me a error after error.Any help regarding this? also sorry for my bad english

sergeibaklan · Answer

Dabudda&nbsp;
I guess you need to use
&nbsp;
=SUMIFS( J7:J16; I7:I16;"*2.1*")
even more exactly perhaps as
=SUMIFS( J7:J16; I7:I16;"*-2.1(*")
to make difference between 2.1, 22.1, 2.10 or so
&nbsp;

jkpieterse · Answer

SUMIF accepts wildcards, so you could do this:=SUMIF(C:C, A:A, "OVR*")or=SUMIF(C:C, A:A, "OVR-2.1*")

dabudda · Answer

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?

hansvogelaar · Answer

Dabudda&nbsp;
Use JKPieterse 's formula but with SUMIFS instead of SUMIF

dabudda · Answer

HansVogelaar&nbsp;Hey thank you.I tried to sort it not via OVR but via the workpackages like 2.1.so now it would be&nbsp;=SUMIFS( J7:J16; I7:I16;"2.1*"), but it gives me 0 as an outcome. Anything i have to do different with numbers ?

Forum Discussion

Trying to gather hours from different workpackages

5 Replies

Resources