|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 16th, 2003, 10:10 PM
|
|||
|
|||
sum minus the smalles cell
Hi All.
How do create a formula which give me the sum of 5 cells minus the smallest cell? eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas eliminate the smalles number (number 3 in this case) and calculate the sum of 10+12+15+14. TIA. Hai 
|
|
#2
September 16th, 2003, 10:16 PM
|
|||
|
|||
|
sum minus the smalles cell
If your cells to sum are in A1:E1, the in F1
=SUM(A1:E1)-Min(A1:E1) Ken "Hai Nguyen" wrote in message ... Hi All. How do create a formula which give me the sum of 5 cells minus the smallest cell? eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas eliminate the smalles number (number 3 in this case) and calculate the sum of 10+12+15+14. TIA. Hai
|
|
#3
September 16th, 2003, 10:30 PM
|
|||
|
|||
|
sum minus the smalles cell
Try using the min function as follows: =SUM(A1:E1)-MIN(A1:E1) Regards, -----Original Message----- Hi All. How do create a formula which give me the sum of 5 cells minus the smallest cell? eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas eliminate the smalles number (number 3 in this case) and calculate the sum of 10+12+15+14. TIA. Hai .
|
|
#4
September 17th, 2003, 06:26 PM
|
|||
|
|||
|
sum minus the smalles cell
Thanks a lot KEN and RICH
Hai "Ken L" wrote in message ... If your cells to sum are in A1:E1, the in F1 =SUM(A1:E1)-Min(A1:E1) Ken "Hai Nguyen" wrote in message ... Hi All. How do create a formula which give me the sum of 5 cells minus the smallest cell? eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas eliminate the smalles number (number 3 in this case) and calculate the sum of 10+12+15+14. TIA. Hai
|
|
#5
September 18th, 2003, 12:17 AM
|
|||
|
|||
|
sum minus the smalles cell
Another possibility;
=SUM(LARGE(A1:E1,{1,2,3,4})) 2rrs "Hai Nguyen" wrote in message ... Thanks a lot KEN and RICH Hai "Ken L" wrote in message ... If your cells to sum are in A1:E1, the in F1 =SUM(A1:E1)-Min(A1:E1) Ken "Hai Nguyen" wrote in message ... Hi All. How do create a formula which give me the sum of 5 cells minus the smallest cell? eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas eliminate the smalles number (number 3 in this case) and calculate the sum of 10+12+15+14. TIA. Hai
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
