Multiple function difficult formula (array, sumif, if, etc)

[SolCo]

I'm looking for a formula (or two), that will allow me to do the following:

For any given project code (column A), if the sum of the ON Shore weights is equal to zero (Column C), then apportion those costs (Column D) which are associated to all the On shore rows (for that given project code) equally across all the Off Shore rows (for that given project code).

And Vice versa

i.e. for any given project code (column A), if the sum of the OFF Shore weights is equal to zero Column C), then apportion those costs (Column D) which are associated to all the OFF shore rows (for that given project code) equally across all the ON Shore rows (for that given project code).

And if both the sum of the On Shore and OFF Shore is not equal to 0, then leave the costs column (D) as it currently is.


I'm having serious trouble with this, if anyone could help me with this, it would be greatly appreciated.
Thanks!!!

PROJECT_ID SHORE WEIGHT Costs Weighted Costs a On Shore 0.1 123 a On Shore 0.1 234 a On Shore 0.8 345 b On Shore 0 543 b On Shore 0.67 432 b On Shore 0.33 527 b On Shore 0 571 c On Shore 1 614 d On Shore 1 658 e Off Shore 0.5 701 e Off Shore 0 745 e Off Shore 0.5 788 e Off Shore 0 832 f Off Shore 1 875 g Off Shore 0 919 g Off Shore 1 962 h Off Shore 1 1,006 i On Shore 0.39 1,049 i On Shore 0.61 765 j Off Shore 1 64 k Off Shore 0 53 k Off Shore 1 576 l On Shore 1 68 <colgroup><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[J.Ty.]

I'm exhausted (it is almost midnight here). I will answer tomorrow. Please select and send me a few examples with wrong calculations in the meantime.

J.Ty.

 

[SolCo]

ok will do..


Thanks for all your help!
really appreciated.

S

 

[J.Ty.]

Dear Soli,

My formulas seem correct to me. I need your examples to make any progress.

J.Ty.

 

[SolCo]

Dear Soli,

My formulas seem correct to me. I need your examples to make any progress.

J.Ty.

Yea, they look good. I use them now and am very happy.
Appreciate your follow up and effort for me!

Best regards

Soli

 

[J.Ty.]

Good luck then!

J.Ty.