View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Excel - Adding positive or negative numbers in a column

Try
=SUMIF(A:A,"0")

--
Jacob (MVP - Excel)


"skygazer" wrote:

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