Dawn

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

Alternative....

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


Gord Dibben Excel MVP

On Wed, 24 Nov 2004 11:09:32 -0700, "Dawn Boot-Bunston"
wrote:

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?