5 Ways to Sum Only Positive or Negative Numbers Separately in Excel Bangla #2018
Channel: Mst. Ruma Khatun
Date: 2018-09-27

5 Ways to Sum Only Positive or Negative Values Seperately in Excel Bangla.
Normally, it is easy for us to sum a range of data in a worksheet, if you are said to sum positive and negative valuse seperately .Here, I want to  sum positive or negative numbers only. Are there any effective ways for solving this problem?
Supposing you have a range of numbers which contains both positive and negative values, and now, you want to sum the numbers regardless of the sign, it means to sum all the numbers as positive values. How could you deal with this problem in Excel?
Here i will show you how to sum positive or negative value/numbers in excel bangla by 5 ways.
Maximum time we are facing this kind of problem. but now time to solve this.

Here i will share 5 Different ways to to solve this project
a. Subtotal
b. Table Option
c. Sumif
d. Sum with Array Formula
e. Sign Function with the help of Sumif

I think from today it will be a easy task to you...

I think you have enjoyed this video.