If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I get to add up only the values than 0?
How do I get to add up only the values than 0?
Only count: =((Q8)*0.5)+(Q8) .... if larger than 0 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|