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
Mike, Sorry, that just is not clear. Perhaps a formula =SUM(A1:A37)/A1 where A1 to A37 have your number 997? Bernie
=COUNT(A1:A37)