show me a result based on ID, SUM and NAME

[Hansulet]

I need a formula to show me results as follows:

For each ID, the formula must show me in column D the first name for which the sum>0 for the same ID.
If sums>0 and the name AFP are found for an ID, then in column D, for this ID, the result is AFP.

ID	SUM	NAME
111	0	AAA
222	200	BBB
333	300	CCC
111	100	DDD
222	0	CCC
333	0	AFP
333	400	AFP
ID	SUM	NAME	RESULT
111	0	AAA	DDD
222	200	BBB	BBB
333	300	CCC	AFP
111	100	DDD	DDD
222	0	CCC	BBB
333	0	AFP	AFP
333	400	AFP	AFP

 

[Hansulet]

Thank you Fluff and AOB. Both formulas are working.

 

[Fluff]

Glad we could help & thanks for the feedback.