# How to sum only positive numbers in Excel

Use SUMIF with ">0", `=SUMIF(C2:C9,">0")`, or with "<0" to add only the negatives.

**Excel:** `=SUMIF(C2:C9,">0")` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E |
| --- | --- | --- | --- | --- |
| Date | Description | Amount |  | Money in |
| 2026-05-01 | Payroll deposit | 3250 |  |  |
| 2026-05-02 | Rent | -1800 |  |  |
| 2026-05-05 | Groceries | -142.67 |  |  |
| 2026-05-09 | Refund | 38.99 |  |  |
| 2026-05-12 | Utilities | -96.4 |  |  |
| 2026-05-15 | Payroll deposit | 3250 |  |  |
| 2026-05-20 | Transfer to savings | -500 |  |  |
| 2026-05-28 | Interest | 4.12 |  |  |

Formula in F1: `=SUMIF(C2:C9,">0")`

Result: $6,543.11

## How it works

With two arguments, SUMIF tests the range and adds the same cells. `">0"` keeps deposits, the refund and the interest, and skips every withdrawal. Zeros are left out too, which doesn't change a total.

## Other ways

- `=SUMPRODUCT((C2:C9>0)*C2:C9)`: The same test written as an array, handy when combined with other conditions.
- `=SUMIF(C2:C9,"<0")`: Money out: the negative amounts. (Returns the withdrawals: -2,539.07.)

## Common mistakes

- Amounts imported as text, like "3,250.00", are skipped. Convert them to numbers first.
- If spending is entered as positive numbers in a separate column, you need SUMIF on a type column instead of the sign.

## Questions

**How do I show money out as a positive number?**

Use `=-SUMIF(C2:C9,"<0")` or `=ABS(SUMIF(C2:C9,"<0"))`.

**How do I sum positive numbers with a date condition too?**

Use SUMIFS: `=SUMIFS(C2:C9,C2:C9,">0",A2:A9,">="&DATE(2026,5,15))`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/sum-only-positive-numbers