Thread: Formula to add up numbers but there are negatives
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Formula to add up numbers but there are negatives
Hi,

Try this

=SUMIF(A1:A6,"0",A1:A6)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Noodlenix" wrote:

Hi,
I want a formula that will just add up the total numbers and disregard the
negatives, is there a true value formula?
Reply With QuoteReply With Quote