View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default sum to = 1 for each cell

I am trying to sum up 37 cells to = 1 each for each cell ex. if i put say 997
in cells i want them to = 1 each so that the sum total = 37 if i put 997 or
any other # in cells