sumif function
triniqueen wrote:
Is there a way I could sum a cell, make it a positive number and add 50, only
if the cell has a negative number in it?
Not sure if this is what you mean:
=IF(A1<0,-A1+50,NA()) // works on one cell only
or, if you want to operate on a range (these are array formulae; commit
with Ctrl+Shift+Enter):
=SUM(IF($A$1:$A$4<0,-1*($A$1:$A$4)+50,0)) // adds 50 to each value
or
=SUM(IF($A$1:$A$4<0,-1*($A$1:$A$4),0))+50 // adds 50 to the result
|