that might be an idea mate, but i want the cells to change the formula individually from one to the next

i think i can't explain it propelry so i'm a bit

say i have one that goes =sum(b4:c4) and it's in the cell f4
when i go to that cell, find the bottom right hand corner and then drag the little cross down, the numbers stay the same on some parts of the page but on others they start to change
for example, dragging the cell down and it changes from b4:c4 to b5:c5 and then b6:c6 and so on
the numbers go up automaticaly
but on other sections of the page the same formula repeats itself when you drag it, so it stays b4:c4 all the way down
i want it to change and the numbers to go up but i can't do it