Thread
:
sum to = 1 for each cell
View Single Post
#
3
Posted to microsoft.public.excel.newusers
Joe User[_2_]
external usenet poster
Posts: 905
sum to = 1 for each cell
"Mike" wrote:
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
=COUNT(A1:A37)
Reply With Quote
Joe User[_2_]
View Public Profile
Find all posts by Joe User[_2_]