Multiple Functions in one cells value =SUMIF and =LARGE

[achilzes]

Hey im a bit new to excel 2013

im trying to get two functions to work in on cell but i cant get it to work.

the two function sounds like.


=SUM('Anders Grønnegaard (1)'!U17;'Anders Grønnegaard (2)'!U17;'Anders Grønnegaard (4)'!U17

the purpose of this line should be it should find the total of the three cells in U17 on the three different sheets. it returns 103 as the total



LARGE('Hold Tabel'!Q17:Q25;ROW(INDIRECT("1:"&ROWS('Hold Tabel'!Q17:Q25))))

that command returns the highest vallue from the sheet named "Hold Tabel"Q17 to Q25 and return it to the cell i type the command in


i have been trying out this so far

=SUMIF('Anders Grønnegaard (1)'!U17;'Anders Grønnegaard (2)'!U17;'Anders Grønnegaard (4)'!U17) & LARGE('Hold Tabel'!Q17:Q25;ROW(INDIRECT("1:"&ROWS('Hold Tabel'!Q17:Q25))))

its close to what i want but as a result i get 0103 and what i want to get is 103 how do i get to the correct result


Hope someone can help me

[vlady]

can't understand the large part since you concatenated sum and the large
you can sum U17 by

=sum(Anders Grønnegaard (1):Anders Grønnegaard (4)!U17)

the large will get the largest value in column Q then what?
you can provide a sample workbook.


To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[achilzes]

i have uploaded the excel im working with

[vlady]

so what is the purpose of the large function, I mean when you get the largest value in column Q then what?

Edit:
have to go... done one of your formulas using one of function i learned from Tony. ty. Tony

look at attachment sheet "Hold Table"
Samlet Resultater.xlsm

[achilzes]

iits beacuse i want the one with the lowest score to be at the top like this example i found from this page thats one of the formular i tried to use.

http://www.excelblog.ca/creating-a-b...st-with-excel/