wadergirl
New Member
- Joined
- Jun 3, 2016
- Messages
- 49
I'm currently using this formula in cell B7 =SUMIF(A1:A7,">0") to sum only the positive amounts in my data set, but I need it as a NEGATIVE.
I know I could use =B7*-1 to turn that positive result into a negative, but I'm having trouble combining the two into a single formula.
This is what I'm trying to get to:
<tbody>
</tbody>
There is no column C in my actual dataset, I've just added it above for illustration that the number in column B should be the opposite of the total in column A so that they net 0.
I know I could use =B7*-1 to turn that positive result into a negative, but I'm having trouble combining the two into a single formula.
This is what I'm trying to get to:
5 | ||
-2 | ||
25 | ||
-8 | ||
-8 | ||
5 | ||
13 | -48 | 0 |
<tbody>
</tbody>
There is no column C in my actual dataset, I've just added it above for illustration that the number in column B should be the opposite of the total in column A so that they net 0.