Excel Formula Home
TradingRothIRA.com - IRA Investment Ideas, News and Stock Analysis Excel Templates!

Excel is a powerful program. However, Excel's powerful features are only as good as the person who can use it.

Now, you can make it more powerful by learning new Excel Formulas. Excel formulas for basic number crunching, as
well as more complex calculations such as payroll deductions, accounting or financial analysis.
 
 
 New Excel Formulas:
How to Summing Only Positive Values

Summary: How to Summing Only Positive Values. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Frank has a worksheet that has a column of data containing both positive and negative values.  He would like to sum only the positive values in the column and is wondering if there is a way to do it.

=SUMIF(A1:A20, ">0")

Download Example