Summing Only Positive Values

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.