View Single Post
  #1   Report Post  
Bryan Hessey
 
Posts: n/a
Default 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