Non-array Formula to SUM (Add) & populate table if value(s) exist in a range of IDs

Looking for non-array formula to populate H2:H91 and I2:I91 by adding all numbers in a unique range (example, add D1:D8 = 7 for Sales ID 11111, formula should populate all Profit for Sales ID). B9:B15 (unique ID is 21222 and B27:B31 unique ID is also 21222 - sum of the two IDs will be different depending on the numbers contained in their respective cells in Profit and Tax column. Formula should consider this scenario where Sales ID will occur more than once (multiple times).

Desired outcome is in green color H2:H91 AND I2:I91.

Reason for non-array formula: Original file has about 200,000 rows. Will reduce computing time in Excel.

See sample file.

Thanks