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])…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar