Sum the lowest 3 results for multiple groups and then identify which group has the lowest

[scross]

Thank you for viewing my query.

I would like to be able to sum the lowest 3 results for multiple groups and then identify which group has the lowest value.
I actually then do the same for the lowest 4 and then 5 results.

I currently use a combination of macros, sorts and then either sums or a physical calculator!
Unfortunately I am under tight time pressures when I need to do these calculations with people waiting for the results.

I have watched videos, read forum posts and webpages and often think yes that's the answer but then I fail to be able to get things to work.
I have tried all manner of sum and small formulas but alas I can't work it out.

Attached a demo spreadsheet with a results tab and a calculations tab that hopefully outlines what I am trying to achieve.
I have added a notes section and listed the criteria I can think of on the first sheet.

Hopefully I have explained what I am trying t o achieve.
Thank you in advance for your time and assistance.

[KOKOSEK]

Excel 2016 (Windows) 32 bit

Total after 3 places	Total after 4 places	Total after 5 places		Winner after 3 places	Winner after 4 places	Winner after 5 places
				Five	Three	Three
				31	57	82
142	213

Sheet: Calculations

Total after 3 places	Total after 4 places	Total after 5 places		Winner after 3 places	Winner after 4 places	Winner after 5 places
=IF(COUNT($C2:$N2)>COLUMN()-14,SUM(OFFSET($C2,0,0,1,COLUMN()-13)),"")	=IF(COUNT($C2:$N2)>COLUMN()-14,SUM(OFFSET($C2,0,0,1,COLUMN()-13)),"")	=IF(COUNT($C2:$N2)>COLUMN()-14,SUM(OFFSET($C2,0,0,1,COLUMN()-13)),"")		=INDEX($A:$A,MATCH(T3,P:P,0))	=INDEX($A:$A,MATCH(U3,Q:Q,0))	=INDEX($A:$A,MATCH(V3,R:R,0))
=IF(COUNT($C3:$N3)>COLUMN()-14,SUM(OFFSET($C3,0,0,1,COLUMN()-13)),"")	=IF(COUNT($C3:$N3)>COLUMN()-14,SUM(OFFSET($C3,0,0,1,COLUMN()-13)),"")	=IF(COUNT($C3:$N3)>COLUMN()-14,SUM(OFFSET($C3,0,0,1,COLUMN()-13)),"")		=MIN(P:P)	=MIN(Q:Q)	=MIN(R:R)
=IF(COUNT($C4:$N4)>COLUMN()-14,SUM(OFFSET($C4,0,0,1,COLUMN()-13)),"")	=IF(COUNT($C4:$N4)>COLUMN()-14,SUM(OFFSET($C4,0,0,1,COLUMN()-13)),"")	=IF(COUNT($C4:$N4)>COLUMN()-14,SUM(OFFSET($C4,0,0,1,COLUMN()-13)),"")

EDIT:
I forget about main data:

Group Names duplicates removed alphabetised		1st position for the group name
Eight		=IF($A2<>"",IFERROR(AGGREGATE(15,4,IF(Placings!$B1:$B201=Calculations!$A2,ROW(Placings!$B1:$B201)-1,""),COLUMN()-2),""),"")

Sheet: Calculations

accept this formula with Ctrl+Shift+Enter and drag it right and down for full table (C2:N31)

[scross]

Thank you Kokosek,

I have my head round the total formulas now thank you.
I initially couldn't understand how the same formula in each cell worked but now I see the -13 signifies the last cell to include.

On the actual spreadsheet I use a button from the home sheet to move to the calculation sheet, run the copying of group names to the calculation sheet, remove duplicate names on the calculation sheet and then sort them alphabetically.
Do you think this is ok to do or do you think I should include all group names in column A on the Calculations sheet by default and make their name blank any row that that doesn't include recorded placings? Hope that makes sense.

I really appreciate your help with this.
Your solution was presented in a very clear and easy to use manner for a novice like me.

Brilliant, thank you!

[KOKOSEK]

You welcome.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.

Depends on situation, but if it is possible, instead of writing different formula, better use row()+12, column() / 7 etc.
I understand that button runs macro. right? Fine. I am lazy, if I have to do something more than twice, I create macro for 1click button


Happy with my answer * Add Reputation.