| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
autosum ??
What formula is used to autosum the two lowest numbers in a group of 4 cells?
a) 2 a) 5 b) 3 b) 4 c) 4 c) 2 d) 5 d) 3 e) e) I need the cell in row "e" to pick-up automatically and autosum the two lowest numbers in rows a,b,c,d. ( 2+3=5) |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(SMALL(A1:B4,{1,2}))
Regards, Peo Sjoblom "golfer18" wrote: What formula is used to autosum the two lowest numbers in a group of 4 cells? a) 2 a) 5 b) 3 b) 4 c) 4 c) 2 d) 5 d) 3 e) e) I need the cell in row "e" to pick-up automatically and autosum the two lowest numbers in rows a,b,c,d. ( 2+3=5) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| the autosum do not working propely ##### THAT WHAT APPEARS PLEA. | Excel Discussion (Misc queries) | |||
| Autosum ignores cell values | Excel Worksheet Functions | |||
| How do I "turn off" cells so they are not included in autosum | Excel Worksheet Functions | |||
| Create AutoSubtotal button which functions like the AutoSum butto. | Excel Worksheet Functions | |||
| autosum problems | Excel Worksheet Functions | |||
Hybrid Mode
