Help me with Sumifs, Index and Match

[lilsaint01]

Good Day sir,

I am creating some formula to make my calculation easier. However i am stuck.
In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18.
I already have formula in there, but idk what else i need to add.

This sheet is working on how many job that 1 employee can do per day. and how much wage that they get per day.

as referenece Row A is "Date" , Row B is "Month" , and Row C is "Year".

What i want is that i can sum total weight (Sheet 2 row V) and wage (Sheet 2 row Q).

The problem is there are job (Sheet 2, AK24 and AK71) that 2 people do at one time, If i write only 1 name the value didnt appear. Please help me, so even with 1 name only, i still can calculating the total.

Thank you. and sorry for my bad english

Please check the file in this link : https://drive.google.com/file/d/1v_Owxx_z5jRJdmLxM4pMDDtqu6qMqVa0/view?usp=sharing

 

[Gerald Higgins]

Seems to be connected to this earlier thread
https://www.mrexcel.com/forum/excel-questions/1109119-please-help-me-sum.html

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1109119-please-help-me-sum.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).