# How to Sum Only Positive Numbers in Google Sheets

To sum only positive numbers in Google Sheets, you can use the SUMIF function. The SUMIF function allows you to set a condition for the values you want to add together. In this case, the condition is that the values must be greater than 0.

Here's a step-by-step guide on how to sum only positive numbers in Google Sheets:

- Open your Google Sheet.
- Click on the cell where you want the sum to appear.
- Type the following formula:
`=SUMIF(range,">0")`

, where`range`

is the range of cells containing the numbers you want to sum. - Press Enter to apply the formula.

For example, if you have a list of numbers in cells A1 to A10 and you want to sum only the positive numbers, the formula would be `=SUMIF(A1:A10,">0")`

.

## Example

Let's say you have the following list of numbers in column A:

```
A
1 -5
2 10
3 -3
4 7
5 -1
6 4
7 0
8 -2
9 3
```

To sum only the positive numbers, follow these steps:

- Click on cell B1 (or any other cell where you want the sum to appear).
- Type the following formula:
`=SUMIF(A1:A9,">0")`

- Press Enter to apply the formula.

The result should be `24`

, which is the sum of the positive numbers (10, 7, 4, and 3).

Did you find this useful?