Spreadsheet Formulas

css navigation by Css3Menu.com

Sum Only Positive Numbers

So you want to add up only the positive numbers in a column.

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:  04/06/2017 20:32
This page added:  07 May 2003