Sum up the daily requirements to match the total objective target

Hello Guys,

In my attached Excel workbook, Range G147:J147 is a formula result of the week's performance, and Range G148:J148 is also the result formula representing the month-to-date performance according to the corresponding week. Range G149:J149 is also a formula result representing the target on a weekly basis. Range G150:J150 is a result of a formula representing the project target on a weekly basis. Range G151:J151 is the Week Target Project Percentage achievement according to the corresponding week. Range G152:J152 is a formula representing the days remaining from the corresponding week, and Range G153:J153 is a formula result representing the corresponding week's daily requirement according to the current week. the full-month sales target is in B144.

My inquiry is in Week #2 Target represented as a formula result in H149 should consider the achievement of Week #1 in G147 and accordingly return the target for the Week #2 rounding the requirement remaining to achieve the week objective target in H150 . currently, I'm using the below formula is working good but the result between H149 and G147 is not matching exactly the week's objective target in H150 ???

Please Login or Register  to view this content.

Book1 - 21-10-2023.xlsx

[ATTACH]846733