Spreadsheet Formulas
Excel VBA
Excel Formulas
User-defined Functions
Excel Links
Access VBA
Access SQL
Alan’s Excel FAQ
Excel Home
Alan’s Home

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-2008

Updated:  04/02/2008 19:33
This page added:  07 May 2003