You can use the following formula to sum only positive numbers in a range in Google Sheets:

**=SUMIF(A2:A16, ">0")
**

This particular formula sums all of the positive numbers in the range **A2:A16**.

The following example shows how to use this formula in practice.

**Example: Sum Only Positive Numbers in Google Sheets**

Suppose we have the following dataset in Google Sheets:

We can use the following formula to sum only the positive values in column A:

**=SUMIF(A2:A16, ">0")**

The following screenshot shows how to use this formula in practice:

The sum of only the positive values in column A turns out to be **27**.

We can confirm this is correct by manually calculating the sum of the positive numbers:

Sum of Positive Numbers: 4 + 1 + 5 + 9 + 2 + 4 + 2 = **27**

This matches the value that we calculated using the **SUMIF** formula.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Use SUMIF Contains in Google Sheets

How to Use SUMIF with OR in Google Sheets

How to Create a Cumulative Sum Chart in Google Sheets