View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
slschram slschram is offline
external usenet poster
 
Posts: 5
Default I did the ABS function for the + and - sum

I entered the suggested ABS function (thank you!) and it worked on those
columns that have a consistent - or + on the number but the columns that have
mixed signs show "#value" instead of the sum total of the numbers......any
suggestions?