Thread: Function for + and - numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
  
Posts: 2,344
Default Function for + and - numbers
Hi,

instead of =SUM(A1:A10)

use =SUM(ABS(A1:A10))

Enter this last formula by pressing Shift Ctrl Enter instead of Enter. Or

=SUMPRODUCT(ABS(A1:A10)) this doesn't need Shift Ctrl Enter

Cheers,
Shane Devenshire
Reply With QuoteReply With Quote