# help

Occasional Visitor

# help

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 .....?