How to Sum and Count Negative and Positive Numbers in Excel?
Usually, we can easily sum or count a range of data in a worksheet. Summing positive numbers is simple, but if the dataset contains both positive and negative numbers, it is difficult to sum only positive or negative numbers separately. Let’s look at how you can use formulas to sum only positive or negative numbers in Excel.
Also, you can use the COUNTIF function to count the number of cells in a range that contain positive and negative numbers.
This Tutorial Covers:
- How to sum only Positive and Negative values?
- How to sum all positive numbers?
- How to sum all numbers greater than a certain value say greater than 500?
- How to sum all negative numbers?
- How to sum all positive numbers or negative numbers from a range?
- How to Count all positive numbers from a Range?
- How to Count all negative numbers from a Range?
- How to sum only Positive and Negative values?
You may need to conditionally add data when working with excel datasheets. In Excel, you may need to sum only the positive integers or only the negative integers. It’s simple to do with Excel’s built-in formulas.
- How to sum all positive numbers?
To calculate the sum of all positive integers, follow the below process:
Step 1: Prepare a data table with the information outlined below:
Step-2: Set a formula in cell B10, outlined below:
The following formula can be used to get the Sum of all positive integers:
=SUMIF(B2:B8,”>0″)
Step 3: Press Enter.
Results outlined below:
3. How to sum all numbers greater than a certain value say greater than 500?
To calculate the sum of all numbers greater than a certain value say greater than 500, follow the below process:
Step 1: Prepare a data table with the information outlined below:
Step-2: Set a formula in cell B-10, outlined below:
The following formula can be used to get the sum:
=SUMIF(B2:B8,”>500″)
Step-3: Press Enter.
Result outlined below:
4. How to sum all negative numbers?
To calculate the sum of all negative numbers, follow the below process:
Step 1: Prepare a data table with the information outlined below:
Step-2: Set a formula in cell B-10, outlined below:
The following formula can be used to get the sum of all negative integers:
=SUMIF(B2:B8,”<0″)
Step-3: Press Enter.
Result outlined below:
Additional:
5. How to sum all positive numbers or negative numbers from a range?
To calculate the sum of all positive numbers, follow the below process:
Step-1: Prepare a data table with the information outlined below:
Step-2: Set a formula in cell B-10, outlined below:
The following formula can be used to get the sum of all positive values:
=SUMIF(B2:C8,”>0″)
Step-3: Press Enter.
Result outlined below:
To sum all negative numbers, follow below process:
Step-1: Prepare a data table with information outlined below:
Step-2: Set a formula in cell B-10, outlined below:
The following formula can be used to get the sum of all negative numbers:
=SUMIF(B2:C8,”<0″)
Step-3: Press Enter.
Result outlined below:
6. How to Count all Positive numbers from a range?
To Count, all positive numbers from a range, follow below process:
Step-1: Prepare a data table with information outlined below:
Step-2: Set a formula in cell B-10, outlined below:
The following formula can be used to get the count of all positive numbers:
=COUNTIF(B2:C8,”>0″)
Step-3: Press Enter.
Result outlined below:
7. How to Count all Negative numbers from a range?
To Count all negative numbers from a range, follow below process:
Step-1: Prepare a data table with information outlined below:
Step-2: Set a formula in cell B-10, outlined below:
The following formula can be used to get the count of all negative numbers:
=COUNTIF(B2:C8,”<0″)
Step-3: Press Enter.
Result outlined below:
