| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula to; sum the lowest 10 cells in a column
Try this:
=SUM(SMALL(A:A,{1,2,3,4,5,6,7,8,9,10})) -- Biff Microsoft Excel MVP "PCat" wrote in message ... sum the lowest 10 cells in a column |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to add 4 lowest numbers from a column of 6 | Excel Worksheet Functions | |||
| HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES | Excel Worksheet Functions | |||
| highlight highest and lowest cells within a given column in ex | New Users to Excel | |||
| highlight highest and lowest cells within a given column in excel | New Users to Excel | |||
| highlight highest and lowest cells within a given column in excel | New Users to Excel | |||
Threaded Mode
