find cost %

[Felix212]

Hello Bro!

Can you please help me with the below formula, the below formula result in #VALUE!
Basically, I want to show % ; cost / sum of all revenue and I don't want to result in div error if not revenue. I'd be happy, if you even suggest me a generally accepted formula for this effort.

IF(L$10:L$14>0,ROUND(L19/L$10:L$14,3),0)

Kind regards

[JohnTopley]

Try

=IF(SUM(L$10:L$14)>0,ROUND(L19/SUM(L$10:L$14),3),0)

or

=IFERROR(ROUND(L19/SUM(L$10:L$14),3),0)

[Felix212]

Many thanks John!
It worked