Family tree
 

I am working on office xp excel spread sheet containg data in two
columns.what function will count row numbers depend on other row numbers.
1 NAME CODE
2 JOHN 3/S
3 ROHIT 7/S
4 RUBY 2/D
5 MONIVA 6/D
6 CATHERINE 7/D
7 JIMMY 0/S
8 LOPAZ 5/S
IN THIS EXAMPLE JOHN IS SON OF ROW 3 PERSON,WHO IS SON OF ROW 7
PERSON.LIKEWISE MONIVA IS DAUGHTER OF CATHERINE ,WHO IS DAUGHTER OF ROW 7
PERSON 'JIMMY'.JIMMY'S CONTRIBUTION TO FAMILY DYNASTY IS 6.MONIVA'S
CONTRIBUTION IS 1.LOPAZ'S CONTRIBUTION IS 0.HOW I CAN COUNT
A ROW PERSON'S CONTRIBUTION TO FAMILY DYNASTY AND DISPLAY THEIR NAMES