I am creating a spreadsheet for an upcoming horse event and need to be able to total the three lowest scores for the team. Team names (listed for each member) are in column Q and the individual scores are listed in column P.

For example:

Col b Col P Col Q
Rider Total Score Team
Pam 43 purple
Jana 50 Red
Mary 22 yellow
Fred 32 purple
John 40 red
Jean 18 yellow
Gene 30 purple
Marc 12 red
Gabi 60 yellow
Sabrina 41 purple
Anna 29 red
Chris 50 yellow

What is the best means of getting the total of the three smallest scores for the team?

Thank you
Mark