Spreadsheet Formulas

css navigation by Css3Menu.com

Sum Only Positive Numbers

So you want to add up only the positive numbers in a column.
=SUM(IF(B10:B40>=0,B10:B40,0))

Enter the formula; then hold Ctrl and Shift while pressing the Enter key to tell Excel Control, Shift + Enter that you are entering an array function.

© 2003-2017

Updated:  09/19/2017 19:26
This page added:  07 May 2003