You can use the following formula to sum only positive numbers in a range in Google Sheets:
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:
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.
The following tutorials explain how to perform other common operations in Google Sheets: