Summing two ranges but only including the positive numbers

[capstonemech]

I have two ranges of numbers that I want to get certain numbers from. When they are summed, some come out as positive numbers, and some negative. I want to collect and sum all the positives together, and all of the negatives together. I know I can do this in multiple steps, but I want to see if I can use some type of SUMIFS or ARRAY to contain this calculation in to one cell gathering the summed positive numbers and one cell gathering the summed negative numbers. See picture for example.

 

[shg]

=sumif(A1:A10, ">0")

 

[capstonemech]

That works great if I want to just SUM positive numbers in one range. My issue is that I want to SUM the numbers provided by adding/subtracting TWO ranges together and then using the numbers based off of the calculation.

Example:
Cell A1 100
Cell B1 50
If I SUM them, I get 150, a positive number.
Cell A2 100
Cell B2 150
If I SUM them, i get -50

it isn't the range of numbers I want to gather and sum, it is the post calculation number that I want to only SUM if it is either a positive number, or a negative number

 

[Aladin Akyurek]

That works great if I want to just SUM positive numbers in one range. My issue is that I want to SUM the numbers provided by adding/subtracting TWO ranges together and then using the numbers based off of the calculation.

Example:
Cell A1 100
Cell B1 50
If I SUM them, I get 150, a positive number.
Cell A2 100
Cell B2 150
If I SUM them, i get -50

it isn't the range of numbers I want to gather and sum, it is the post calculation number that I want to only SUM if it is either a positive number, or a negative number

Not clear... How or why do you get -50 when you SUM A2 and B2?

 

[c_m_s_jr]

Assuming the answer to Aladin's post is that you are actually wanting to Subtract Column A from Column B and only sum when the resulting value is positive:

in a separate cell:

{=SUM(IF($A$2:$A$10-$B$2:$B$10>0,$A$2:$A$10-$B$2:$B$10))}

confirm with contrl+shift+enter to put the {} as this is an array.

I am betting though that this is a better solution.

 

[capstonemech]

This worked exactly as I needed it to.

And yes I meant subtracted...sorry about the confusion.

Thank you so much