Thread: Count max of x values
View Single Post
 
Old 05-10-2016, 05:49 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Quote:
Originally Posted by timbrignall View Post
Is it possible to count only the six largest values from a set of 10 values in a row?
Count? Easy. There will be six of them. ;-)

Sorry, did you mean sum? If so, then yes.

=SUMPRODUCT(LARGE(range,{1,2,3,4,5,6}))
Reply With Quote