Thread: Problem solver needed

Hi everybody!

I have a problem that I need help with. It is driving me crazy

In Sheet 1 I have the following 3 columns:

Name----Score----Family
Eric........7............Anderson
John.......10..........Doe
Jennifer...4............Doe
Bill..........5............Hawkins

And in Sheet 2 I have following 3 columns:

Name-----Age---FamilyScore
Bill...........12.......?
John........18.......?
Eric..........23......?
Jennifer....11.......?

My objective is to give FamilyScores to the names in Sheet 2. If there would only have been one member per family, this could be done by just taking the Score from Sheet 1 using the VLookup function. But this is unfortunately not the case...

If several people come from the same family, their scores should add together. The oldest family member should be given the total score, and the rest should be left with 0.

I.e. the result should in this case be:

Name-----Age---FamilyScore
Bill...........12.......5
John........18.......14 (10+4)
Eric..........23......7
Jennifer....11.......0

I have experimented with VLookup and some other functions, but I haven't got it to work. Can somebody help me out?

P.S. the names in the Name column are unique

Please read our Forum Rules about thread titles, and then start a new thread with an appropriate title.

Thanks.