Bryan Hessey

Posts: n/a

Select the Top 20 within a formula

How can I select the top 20 within a formula so that I can
=sum( ~~ select top 20 from a range I$56:I100~~ )

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=385482

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Select header if formula	Krista F	Excel Worksheet Functions	11	April 11th 05 07:26 PM
Howdo U copy a formula down a column, that uses data in another w.	Need Help pasting a formula	Excel Worksheet Functions	1	February 25th 05 06:04 PM
Howdo U copy a formula down a column, that uses data in another w.	brantty	Excel Worksheet Functions	0	February 25th 05 10:11 AM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"