software

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?

you can try this

=SUMIF(A1:A30,quot;lt;0quot;,A1:A30)--
Regards Ron de Bruin
www.rondebruin.nlquot;GladesTigerquot; gt; wrote in message ...
gt; I'm trying to add up the negative values in a column with positive values as
gt; well. Lotus has a sumnegative function that would just add those cells that
gt; contained a negative value. Does Excel have a similar function?
Use sumif function like:

=SUMIF(A1:A999,quot;lt;0quot;)

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

quot;GladesTigerquot; gt; wrote in message
...
gt; I'm trying to add up the negative values in a column with positive values
gt; as
gt; well. Lotus has a sumnegative function that would just add those cells
gt; that
gt; contained a negative value. Does Excel have a similar function?
Hi,

Though sumif is definitely the best function to use, you may also use an
array formula (Ctrl Shift Enter)

=sum(if((rangelt;0,range)) confirmed by Ctrl Shift Enter

Regards,

Ashish Mathur

quot;GladesTigerquot; wrote:

gt; I'm trying to add up the negative values in a column with positive values as
gt; well. Lotus has a sumnegative function that would just add those cells that
gt; contained a negative value. Does Excel have a similar function?