Formula to calculate only the negative numbers

  • Thread starter Thread starter Dawn Boot-Bunston
  • Start date Start date
D

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

=SUMIF(D1:D100,"<0",D1:D100)

Alternative....

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


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

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

HTH
 
You must log in or register to reply here.

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

Rounding Negative Numbers to Zero 4
How do I limit formula results to positive only? 4
Scrabble Value calculation for Welsh words 0
Excluding Negative Numbers 9
How do I create the formula for this calculation? 1
Calculate only Positive Numbers 3
Negative time calculations 4
formula to a minimum value of zero if a negative number 2

Back
Top