| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula can I use to sum largest 2 numbers out of data set?
I'm creating a spreadsheet to add up scores but only want the highest 2
values out of 4 to be added together? What formuls could I use to do this? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What formula can I use to sum largest 2 numbers out of data set?
Hi
Try this: =SUM(LARGE(A1:A4,{1,2})) A1:A4 range needs to be changed to suit your requirements. HTH Michael M "Excel Novice" wrote: I'm creating a spreadsheet to add up scores but only want the highest 2 values out of 4 to be added together? What formuls could I use to do this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum largest numbers based on condition | Excel Worksheet Functions | |||
| Pulling the largest numbers | Excel Worksheet Functions | |||
| Highlighting the 5 Largest Numbers in a list | Excel Discussion (Misc queries) | |||
| 3 largest numbers | Excel Discussion (Misc queries) | |||
| average of kth largest numbers in an array of n numbers | Excel Worksheet Functions | |||
Linear Mode
