count Special Leave max 10 days only

Hi Excel Experts,
I'm using the mobile app right now to compose a new thread but on top of the title shown "[SOLVED]" by default and it doesn't gv any other option. Pls treat this as a new thread and fix the above if it's a bug.Thx.

Am trying to create a template that can count number of leaves.there are several types of leaves and each of them I use CountIF.However, there is this one called Special Leave which a combunation of 3 types of leaves - marriage leave (WL), compassionate leave (CL), Paternity Leave (PL). A staff is allowed to take any of these leaves max 10 days in a yr.

It's bn so challenging for me to create a formula that will check whthr 3 leaves is less than 10 then if it's more need to adjust how many leaves will b counted to allow until 10 only as total and d rests will be pushed as Unpaid Leave (UL).

Appreciate if anyone can help on the formula.

Thank you in advance.

More simple explain the problem with the small sample workbook and try upload it to the forum

Regards
Azumi