Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SMALL function seems not to work correctly
I can't seem to get the SMALL function to work for me the same way the
LARGE function does. Say I have a table of two columns with the data in the first column A1:A6 (range called TABLE) being se****ial numbers 1 thru 6 and a second column B1:B6 (range called TARGET) with B1:B3 each = 1 and cells B4:B6 each = 0. When I put the following formula in C1 as an array formula {=SUM(LARGE((TARGET=1)*TABLE,ROW(INDIRECT("1:2"))) )} It gives me the right answer, or at least what I expected it to give me, the value of 5. It sums the two largest numbers in the range TABLE that first met the criteria set out for the range TARGET. However, when I use the exact same formula, but substitute the LARGE function for SMALL, it gives me a value of 0. I thought it should give me a value of 3 (which is the sum of the two smallest numbers that meet my criteria). {=SUM(SMALL((TARGET=1)*TABLE,ROW(INDIRECT("1:2"))) )} What is wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Small game wont work in Excel 2007 | Excel Discussion (Misc queries) | |||
Sorting numbers doesn't work correctly | New Users to Excel | |||
How do I get Auto-Fit to work correctly? | Excel Worksheet Functions | |||
custom filter does not work correctly | Excel Discussion (Misc queries) | |||
office 97 small business edition, excel does not work on xp | Setting up and Configuration of Excel |