Picking Highest numbers out of List

		Microsoft Office Forums > Microsoft Excel > Excel
Picking Highest numbers out of List

FAQ

Thread Tools

Display Modes

03-08-2018, 12:11 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 932

Let's say, you numbers are in range A2:A21.
Into second column enter the formula (p.e. into cell B2)

Code:

=(SUM($A3)=0)

NB! The formula refers to next row in column A!
Copy the formula down into range B2:B21.

Into any cell where you want the end result, enter the formula

Code:

=SUMIF($B$2:$B$21,TRUE,$A$2:$A$21)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Picking value from a certain cell under certain conditions	kao	Excel	1	09-07-2017 09:34 AM
Average of highest 7 out of nine quizzes	wallace990	Excel	2	05-16-2017 01:51 PM
Fetch highest number	am_gup123	Excel	2	03-23-2017 01:56 AM
Highest & lowest Numbers	ibrahimaa	Excel	3	04-23-2012 07:52 PM
Page number picking up heading numbering?!	Ulodesk	Word	0	09-24-2009 01:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:26 PM.