Two Issues:

1. The number of people in your team can change
2. The output shouuld show your team mates individual rankings of you, and a sum, not just the sum itself.

I didn't think it could be done unless I worked with some macro. I don;t know, this is giving me a headache and I am going home for the day!! HAH