N/A Error

[u0708566]

Why isn't this working!! Not sure why I am getting an N/A error.

[#2]

@u0708566 

Just a guess. Put SUM() around Fixed_Costs.

Otherwise provide a sample workbook with expected results.

[#3]

@Detlef_Lewin 

Thanks! That helped so I didn't get an error, but I think I did something else wrong. The net income * the ownership share of 40% is supposed to equal 344k (which is the XYZ share).

On this sheet I got 63,339,648 for the net income, and 25,335,859 for the XYZ share. Lmk what you think i did wrong.