Thread: Picking Highest numbers out of List
View Single Post
 
Old 03-08-2018, 12:11 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
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)
Reply With Quote