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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|