Count max of x values

		Microsoft Office Forums > Microsoft Excel > Excel
Count max of x values

05-10-2016, 05:49 AM

gebobs

Windows 7 64bit Count max of x values

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

Quote:

Originally Posted by timbrignall

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}))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM
Count	Cokeman6	Excel	1	09-09-2015 08:00 AM
Display unique values and count the number of child items	vthomeschoolmom	Excel	2	07-25-2013 06:17 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 AM.