A B C
| | | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
| 2 | #DIV/0! | #DIV/0! | |
Cell (130)
So lets say the sum of the columns of A is 20 and you keep adding to it, but you want to divide the next column B, but you don't want to keep manually inputting the cell number. When I do this formula =SUM(I77/I130), but when I copy that formula, into the cells below, now i get the an error, I want to keep the I130 constant and only change the I77 ........ is that possible .....?
