Formula to calculate only the negative numbers

[Dawn Boot-Bunston]

Hi Again,

This time I won't be attaching a workbook...I apologize again for my earlier
post. I have another inquiry....this time I need to create a formula that
will calculate only the -negative numbers found within a column. Is this
possible?

 

[peter]

Hi,
Try this...
=SUMIF(E8:E13,"<0",E8:E13)
peter

 

[Myrna Larson]

YOu don't need to attach a workbook, and very probably nobody will open it if
you do, because of the risk of viruses.

What do you mean by "calculate"? If it's SUM or COUNT, use SUMIF or COUNTIF.
If it's some other calculation, please explain. You may need a SUMPRODUCT or
array formula.

 

[Dawn Boot-Bunston]

Thank you VERY much, Peter! This works perfectly!

 

[Gord Dibben]

Dawn

=SUMIF(D1100,"<0",D1100)

Alternative....

=SUMIF(D,"<0",D)


Gord Dibben Excel MVP

 

[Dana DeLouis]

Just to mention. The 3rd option is assumed if it's the same range.

=SUMIF(A1:A10,"<0")

HTH