Thread: Does Excel have a "sumnegative" function like Lotus?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin
 
Posts: n/a
Default Does Excel have a "sumnegative" function like Lotus?
you can try this

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


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


Reply With QuoteReply With Quote