help

Occasional Visitor

 

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

 

 

1 Reply

@AirportAgent 

Use

 

=SUM(I77/I$130)