| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum of Max cells in a range
Any way to find out the sum of the three greatest values out of a range of 20
cells all in the same row? I'm going crazy... |
|
#2
|
|||
|
|||
|
One way
=SUMPRODUCT(LARGE(A4:T4,ROW(INDIRECT("1:3")))) -- Regards, Peo Sjoblom "Merrick" wrote in message ... Any way to find out the sum of the three greatest values out of a range of 20 cells all in the same row? I'm going crazy... |
|
#3
|
|||
|
|||
|
Try the following...
=SUM(LARGE(A1:A20,{1,2,3})) Hope this helps! In article , "Merrick" wrote: Any way to find out the sum of the three greatest values out of a range of 20 cells all in the same row? I'm going crazy... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Formula help for using a range of cells! | Excel Worksheet Functions | |||
| How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
| Excel-value in a range of cells for two cross references | Excel Worksheet Functions | |||
Linear Mode
