how to get expected value/result based on multiple criteria ?

Hi to all experts,

let me explain you that what exactly I required because to get these result m fade up with trying.

ok here I start,

I want my result on Summary Sheet at Cell F13 & G13, my formula should totally depends on Data Date (C3).

Therefore, if (C3) equals to ('P1-Detail'!L2) then entire % of this column should subtract from column ('P1-Detail'!L7:L1948 to 'P1-Detail'!K7:K1948) (i have it manually) in order to get periodic % of the week. Afterwards, I got the result let say 50% at cell 'P1-Detail'!M7 (50%) then this 50% should multiply with 'P1-Detail'!D7 (manually calculated) taking into consideration cell P1-Detail'!C7 & 'P1-Detail'!E7.

At last the desired result I want to save my time from manual calculation.

Hope I tried my level best to explain what i want. For the result you can refer to cell N12:Q18.

thanks in advance.

One approach attached, new formulae highlighted in green.

Of course I've assumed that the columns M:O on P1-Detail are there purely to facilitate your expected results.

Note: given use of SUMPRODUCT etc I have created a Dynamic Named Range to limit the size of the dataset reviewed.