Sum Only Positive Numbers or Negative Numbers in Excel

This post will guide you how to sum only negative numbers in Excel. How to sum only positive numbers in Excel. How do I sum both positive and negative numbers in Excel. How to make the sum in a range show as a negative number in Excel.

Sum Only Positive Numbers or Negative Numbers


If you want to sum only positive or negative numbers in excel, you can use a formula based on the SUMIF function.

For example, you have a range of cells (A1:C4) that contain negtive and positive numbers, and you want to sum only positive numbers, you can use the following formula:

=SUMIF(A1:C4,">0")

Type this formula into a blank cell and then press Enter key.

sum positive negative numbers1

If you want to sum only negative numbers in a given range of cells, you can use the following formula:

=SUMIF(A1:C4,"<0")

 sum positive negative numbers2

Related Functions


  • Excel SUMIF Function
    The Excel SUMIF function sum the numbers in the range of cells that meet a single criteria that you specify. The syntax of the SUMIF function is as below:=SUMIF (range, criteria, [sum_range])…
Related Posts

How to Sum if Equal to Many Items or A Range in Excel

If we want to sum numbers from a range with criteria, we often select SUMIF of SUMIFS functions as the first choice to create a formula. The criteria can be a number or an array or a collection of some ...

How to Sum if Equal to X or Y in Excel

In daily work, if we want to sum numbers from a range, and only sum the numbers which being equal to X or Y in the range, we can create a formula with Excel build-in functions to get the result. ...

How to Sum Last N Days in Excel

In our daily life, we may want to sum amounts or sales for a specific period, for example in last N days. Sum numbers in Excel is easy to run, we can apply SUM function. But if we want to ...

How to Sum if Contains an Asterisk

To add numbers together we need to apply SUM function. And if we want to add numbers based on some conditions, we can add criteria with the help of SUMIFS function, SUMIFS can filter data with multiple criteria effectively. If ...

How to Sum in Vertical Range

If we want to add numbers based on some conditions in Excel worksheet, we can add criteria with the help of SUMIFS function, SUMIFS can filter data with multiple criteria effectively. In this article, we will introduce you the method ...

Sidebar