Try something like this:

=-ABS(SUM(A1:A10))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Mtabaruka" wrote:

I am doing a sum but I want to always return the result as a negative value
even if its positive e.g if my result of =sum(a1:c1) is 10 I want to get the
result as -10
--
Wether you think you can or you think you cant , you are right ... anon