LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hdf hdf is offline
external usenet poster
 
Posts: 30
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Small game wont work in Excel 2007 Phil Excel Discussion (Misc queries) 4 April 3rd 07 10:24 AM
Sorting numbers doesn't work correctly GrammyEmmy New Users to Excel 8 June 25th 06 11:45 PM
How do I get Auto-Fit to work correctly? Mickey Dunne Excel Worksheet Functions 0 May 11th 06 01:47 AM
custom filter does not work correctly RJ Excel Discussion (Misc queries) 1 September 9th 05 07:34 PM
office 97 small business edition, excel does not work on xp suncityart Setting up and Configuration of Excel 2 July 13th 05 02:20 AM


All times are GMT +1. The time now is 03:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"