Thread: How do I get to add up only the values than 0?
View Single Post
  #3   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?
OR use MAX() as below

=MAX(0,Q8)

=(MAX(0,Q8)*0.5)+MAX(0,Q8)

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

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