Thread: How to add all positive and negative numbers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How to add all positive and negative numbers?
=SUMIF(A1:A100,"<0")

--
Regards,

Peo Sjoblom

(No private emails please)


"Knold10" wrote in message
...
I am doing a template regarding standard usage of an item. It has negative
and positve standard usage. How can i add all negative?

Reply With QuoteReply With Quote