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:
Type this formula into a blank cell and then press Enter key.
If you want to sum only negative numbers in a given range of cells, you can use the following formula:
- 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])…