LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jub366
 
Posts: n/a
Default Help, how to find a range of data?


If i have a numbers in the cell . eg : 1.1 , 1.2 , 1.3 , 2.1 , 2.2 , 2.3


for this numbers i want to find say like 3 smallest number then Sum it
up.

it will be equal to 1.1 + 1.2 + 1.3 = 3.6

question is what function should i be using ?


thanks


--
jub366
------------------------------------------------------------------------
jub366's Profile: http://www.excelforum.com/member.php...o&userid=27985
View this thread: http://www.excelforum.com/showthread...hreadid=474925

 
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
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
Help! Selecting data according to date range redbna Excel Discussion (Misc queries) 0 June 8th 05 06:58 PM
data range properties baz Excel Discussion (Misc queries) 0 April 1st 05 08:53 AM
How can I check if data in external data range is changed after re Ruud Excel Discussion (Misc queries) 0 January 7th 05 12:07 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 09:07 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"