View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Susan Susan is offline
external usenet poster
 
Posts: 271
Default SUM negatives numbers as positive

The range of numbers in a SUM formula includes some negative values, but I
would like the negative values included in the SUM as positives. I need the
negative values in the range to stay displayed as negatives.