sumif function
Thanks JE, I did try using ABS before but I didn't quite use it like you
showed. You guys have been great!!!
--
Ksy
"JE McGimpsey" wrote:
For one cell:
=IF(A1<0,ABS(A1)+50,A1)
for a column, one way:
=SUMIF(A1:A100,"0")-SUMPRODUCT(--(A1:A100<0),A1:A100-50)
another alternative:
=SUMPRODUCT(ABS(A1:A100))+COUNTIF(A1:A100,"<0")*50
In article ,
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?
|