Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula to; sum the lowest 10 cells in a column
sum the lowest 10 cells in a column
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula to; sum the lowest 10 cells in a column
You mean lowest 10 values in a column...Try
=SUMPRODUCT(SMALL(A:A,ROW(1:10))) If this post helps click Yes --------------- Jacob Skaria "PCat" wrote: sum the lowest 10 cells in a column |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula to; sum the lowest 10 cells in a column
Perhaps you mean the last 10 numbers in a column
=SUM(OFFSET(A1,COUNTA(A:A)-10,):OFFSET(A1,COUNTA(A:A),)) Mike "PCat" wrote: sum the lowest 10 cells in a column |
#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 |
Reply |
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 |