Vlookup + Index + Match to find value

[Odair]

hello, I am looking to solve this problem which my be easier than I expect.

I want to look up values ( foexample "META"and "OP1" to find the hours next to "OP1" so I can sum all of it at the end to get a total.

Sheet : Informatics - in the Cell "J6" I have to get the sum of all the "OP 1" in the "META" column that can be found in sheet: JAN20

Sheet : Informatics - in the Cell "K6" I have to get the sum of all the "OP 2" in the "META" column that can be found in sheet: JAN20

and so forth and so on

So I thought it would work with Vlookup and index and match, but it isnt.

I put some pictures and the excel file to explain a little bit more.

thanks in advance

[Sam Capricci]

I would think a sumif would work for that unless I'm missing something, something like... =SUMIF('JAN 20'!$D$11:$D$40,J$5,'JAN 20'!$E$11:$E$40)
you may want to adjust the locks so it could be dragged right, maybe like =SUMIF('JAN 20'!D$11:D$40,J$5,'JAN 20'!E$11:E$40) which will lock in the rows but not the columns.
not sure what outcome you are looking for but from what I could tell this might be it.

[Odair]

Thats a good start, to solve the equation issue, thank you very much for that but how do I get it to look up for 'META' first as in the other spreadsheets it can be in another colum (the Yellow outline in the pictures). If I solve this I think the question is then solved.

Thanks alot Sambo kid

[Odair]

I figured it out thanks to ou it was like this :

=SUMIFS(INDEX('JAN 20'!$D$11:$U$40,0,MATCH($C$6,'JAN 20'!$D$9:$U$9)),'JAN 20'!$D$11:$D$40,Informatics!J5)

Now I need figure out how to make it take in consideration every sheet instead of just JAN