Formula sum-if

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

Hi all

The situation is:
1. I have an amount in cell D200. 2. I have amounts in cells E210:E300. I
need a formula in D202 that will sum any negative amounts that might be in
the E cells, and then add the answer to the amount in D200. Otherwise cell
D202 should just reflect the amount in D200.

Can anyone help? Thanks in advance and I always leave feedback.

I hope you all have good Holidays! Mine will be very good if I can solve
this:-)
 
You may want to have a try on this;

In the D202 cell, you may type this formula

=ABS(SUMIF(E210:E300,"<=0"))+D200

Hope it helps.

AnthonyHo2008
 
Once again I say a big thanks to you, sir! It worked perfectly. With the
other formulas, I ended up with a larger number and, of course, I actually
needed a smaller number.

Thanks again and have nice holidays...
 
Hi Anthony

Sorry, I should have said "combine the two amounts together", and then it
would have been clearer as to what I needed. Your formula inverses the
negative numbers and then adds the two amounts together, which is pretty
cool, also. I'll keep this one in case I need it later on. T Valco's
formula does what I need this time.

Thanks for the response
 
Back
Top