=sumif(a1:a10,""&0) - sumif(a1:a10,"<"&0)

You could also this:
=sum(abs(a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.



Cotton Girl wrote:

On my budget page, there are negative numbers when an expenditure is more
than the budgeted amount. I need these negative numbers to be added to the
total sum instead of substracting it from the total sum. How do I do this?
--
Cotton Girl

--

Dave Peterson