Thread: Excel - Adding positive or negative numbers in a column
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Excel - Adding positive or negative numbers in a column
Use SimIf

=SUMIF(A1:A10, "0", A1:A10)
--
HTH...

Jim Thomlinson


"skygazer" wrote:

How do I add only the positve numbers in a column with both positive and
negative numbers?
Reply With QuoteReply With Quote