Distribute an amount according 2 variables

[Sybille]

Hello Forum,

Can you please help me with the formula I am looking for, according to the attached file?
The goal is to distribute an amount in the x (variable) columns before the one containing a certain value.

Thank you in advance!

[Bo_Ry]

Please try at B13
=IF(ABS(MATCH("*",$B11:$K11,)-COLUMNS($B12:B12)-($B$3+1)/2)<($B$3+1)/2,$B$4/$B$3,"")

[Sybille]

Hello Bo_Ry,

Works perfectly Thank you very much, thread solved!