| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to add 4 of 5 highest numbers using a formula
How to make a formula for this problem in Excel
|
|
#2
|
|||
|
|||
|
Hi
=SUM(A1:A5)-MIN(A1:A5) Arvi Laanemets "jost" wrote in message ... How to make a formula for this problem in Excel |
|
#3
|
|||
|
|||
|
or
=SUM(LARGE(A1:A5,{1,2,3,4})) -- HTH RP (remove nothere from the email address if mailing direct) "Arvi Laanemets" wrote in message ... Hi =SUM(A1:A5)-MIN(A1:A5) Arvi Laanemets "jost" wrote in message ... How to make a formula for this problem in Excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
