Adding only negative numbers in row

  • Thread starter Thread starter jordanpcpre
  • Start date Start date
J

jordanpcpre

I have a list of numbers in a row that has both positive and negative numbers
throughout the row. Is there a way I can get a sum of only the negative
numbers?

The row is very long so I would rather not add the negatives one by one. Is
there a formula that will seek only the negative numbers and add them all up?

Thanks!
 
The following formula should do the trick, just adjust the cell addresses to
match your row dimension:

=SUMIF(A1:F1,"<0")
 
Try something like this:

This formula sums the negative numbers in row 3:
=SUMIF(3:3,"<0")

Or...if you are using a range:
This formula sums the negative numbers from A3:Z3
=SUMIF(A3:Z3,"<0")

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Numbers 8
Adding Negative and Positive Numbers 4
Excel - Adding positive or negative numbers in a column 5
Flipping numeric values 3
Help with positive and negative numbers 1
how do I add only positive numbers in a range 3
Delete all negative numbers leaving only positive numbers 8
Maximum negative number 1

Back
Top