Spreadsheet Formulas
Excel VBA
Excel Formulas
User-defined Functions
Office 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-2011

Updated:  09/11/2011 15:58
This page added:  07 May 2003