Thread: How do I get to add up only the values than 0?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default How do I get to add up only the values than 0?
Use SUMIF()

=SUMIF(Q8,"0")

or

=SUMIF(A1:A10,"0")

--
Jacob (MVP - Excel)


"Anri" wrote:

How do I get to add up only the values than 0?

Only count: =((Q8)*0.5)+(Q8) .... if larger than 0
Reply With QuoteReply With Quote