Summing Positive and Negative Numbers Separately

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/summing/summing-positive-and-negative-numbers-separately.html">
SHARE




In this article, we are going to learn how to calculate the sum of positive and negative numbers separately on the basis of criteria. We will use SUMIF function to sum up the positive and negative numbers.

Let’s take an example and understand:-

We have an agency’s car sales data. In data we have sales details along with discount detail. Now, we want to calculate the sum for every manufacturer sales amount and discount amount. Also, in data, discount amount is in negative numbers so we want to return the total sum of negative number as well.

 

image 1

 

How to calculate the sum of positive numbers?

To calculate the positive numbers, we will use SUMIF function, follow below given steps:-

  • Enter the formula in cell I2
  • =SUMIF($A$2:$F$17,H2,$E$2:$E$17)
  • Press Enter and copy the same formula in range.

 

image 2

 

How to add negative numbers?

To calculate the sum of negative numbers, we will use SUMIF function. We need to follow below given steps:-

  • Enter the formula in cell J2
  • =SUMIF($A$2:$F$17,H2,$F$2:$F$17)
  • Press Enter and copy the same formula in range.
  • When we use the formula (-) sign will be deleted.
  • Press Ctrl+1 format cells, and a dialog box will appear.
  • Format Cells > Numbers > Custom

image 3

 

 

  • Click on OK.

image 4

 

This is the way we can use SUMIF to calculate the negative and positive number in the data of Microsoft Excel.

 

image 4

 

Please follow and like us:
25


Leave a Reply

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


nine × 3 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>