| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum to = 1 for each cell
Mike,
Sorry, that just isn't clear. Perhaps a formula =SUM(A1:A37)/A1 where A1 to A37 have your number 997? Bernie "Mike" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Linear Mode
