excel formula question

Question

Hello all ...

If you have both positive/negative numbers in one column, what formula would you use to create a subtotal of the - negative numbers in that column?

Many thanks in advance

Answer 1

Hi Gail KOHLMAN,

Thanks for your valuable feedback and I appreciate your kind words.

Meanwhile, if you find our suggestions helpful, if possible, you can also use the feedback tool (below) to submit your feedback for us.

Your feedback really means a lot to the dedicated members of our community.

If there are any issues with Office apps in the future, feel free to post to this community again.

We will be there to help you.

Have a great day and stay safe 😊

Sincerely

Waqas Muhammad

Answer 2

Thank you Rich~M .... I appreciate the help along with showing the positive (total) number scenario!

Answer 3

Thank you! I appreciate the help along with the sample ... made understanding much easier.

Answer 4

Dear respected Gail KOHLMAN,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description,

=SUMIF(A:A, "<0")

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 5

I assume that when you say sub-total you are simply wanting to separate the total of the negatives for the entire column. You can use this formula to total only the negative numbers in a range. Modify according to your actual data location.

=SUMIF(A2:A12,"<0")

To total only the positive numbers just change the < to >.

=SUMIF(A2:A12,">0")