How to Sum Only Positive Numbers in Excel (4 Simple Ways)

We’re going to use a sample dataset as an example. The following dataset represents the Profit/Loss in the first 5 Days of January of a store.

Download the Practice Workbook

Sum Positive Numbers.xlsm

4 Simple and Effective Ways in Excel to Sum Positive Numbers Only

Method 1 – Sum Only Positive Numbers by Applying the SUMIF Function in Excel

STEPS:

Select cell C10.
Insert the formula:

=SUMIF(C5:C9,">0")

Press Enter and you’ll see the expected result.

Method 2 – Use an Excel Table to Sum Positive Numbers Only

The Excel Table feature is really helpful while doing operations following certain conditions. In this method, we are going to use the Table feature in Excel to Sum Positive Numbers Only.

STEPS:

Select the range of cells you want to work with.

Select the Table feature under the Insert tab.

A dialog box will pop out.
Check My table has headers and press OK.

You’ll get a Table.

Select the arrow for Profit/Loss.

Select Number Filters.
Select Greater Than.

A new dialog box will pop out.
Type 0 in the first input box and press OK.

You’ll see your Table with only the Positive Numbers.

Click any cell inside the Table.
Check the Total Row feature under the Table Design tab.

You’ll get the Sum in the cell right under the Table.

Similar Readings

Method 3 – Applying a Filter to Sum Positive Numbers in Excel

We’ll use the same dataset.

STEPS:

Select the Filter feature under the Data tab.

Select the drop-down arrow for Profit/Loss.

Select Number Filters.
Select Greater Than.

A new dialog box will pop out.
Type 0 in the first box and press OK.

You’ll get only Positive Numbers.

Select cell C11.
Press Alt + =.

Press Enter and the Sum will appear in cell C11.

Method 4 – Sum Only Positive Numbers with Excel VBA

STEPS:

Select the Visual Basic feature in the Developer tab or press Alt + F11.

A window will pop out.
Select the Insert tab.
Select the Module option.

Another window will pop out.
Copy the Code given below and paste it into the Module window.

Sub add_positive_numbers_only()
Dim sheet As Worksheet
Dim rg As Range
Dim result As Range
Set sheet = Application.ActiveSheet
Set rg = Application.Selection
Set result = Application.InputBox( _
Title:="Select the Cell for Showing Result", _
Prompt:="Select the Cell where you want to see the Sum", _
Type:=8)
result.Value = Application.WorksheetFunction.SumIf(rg, ">0")
End Sub