Use sumif function like:
=SUMIF(A1:A999,"<0")
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - -
www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"GladesTiger" wrote in message
...
I'm trying to add up the negative values in a column with positive values
as
well. Lotus has a sumnegative function that would just add those cells
that
contained a negative value. Does Excel have a similar function?