Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
Alma has a worksheet that has a column of data containing both positive and negative values. She would like to sum only the positive values in the column and is wondering if there is a way to do it.
Fortunately Excel provides a convenient worksheet function you can use for just this purpose. Suppose, for instance, that all the values were in column A. In a different column you could enter the following formula:
=SUMIF(A:A,">0")
The SUMIF function returns a sum of all values in the range (A:A) that meet the criteria specified (>0). Any other values—those less than or equal to 0—are not included in the sum.
If you don't want to use SUMIF on an entire column, a simple modification in the range being evaluated can be made:
=SUMIF(A1:A100,">0")
Here only the range of A1:A100 is being evaluated and included in the sum.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3349) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.