Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Count max of x values
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-10-2016, 05:33 AM
timbrignall timbrignall is offline Count max of x values Windows 7 32bit Count max of x values Office 2013
Novice
Count max of x values 		 
Join Date: May 2016
Posts: 1
timbrignall is on a distinguished road
Default Count max of x values
Is it possible to count only the six largest values from a set of 10 values in a row?
Reply With Quote
  #2  
Old 05-10-2016, 05:49 AM
gebobs gebobs is offline Count max of x values Windows 7 64bit Count max of x values 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
  #3  
Old 05-10-2016, 07:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Count max of x values Windows 7 64bit Count max of x values Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Quote:
Originally Posted by gebobs View Post
Count? Easy. There will be six of them. ;-)
You'll never cease to astonish me
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
count, max

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count max of x values 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
Count max of x values Display unique values and count the number of child items vthomeschoolmom Excel 2 07-25-2013 06:17 AM
Count max of x values 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 04:57 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft