Formula sum-if

[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

 

[AnthonyHo2008]

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

 

[smartin]

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

Try this array-entered formula:

=D200+SUM(IF(E210:E300<0,E210:E300))

Happy Holidays!

 

[T. Valko]

Try this:

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

 

[Ross]

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...

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Ross]

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