#### macro_user

##### Board Regular

- Joined
- Mar 9, 2009

- Messages
- 101

i need to implement this formula in a macro for all the rows in the worksheet.

E11=INT(SUM(DJ9:ER9)/(3*20*15)*100)

this formula is to find the sum of all numbers from DJ9 to ER9 and then multiply and divide by integers...

how do i put this formula in a loop so that it finds the sum of all numbers tilll row number 50?

Appreciate ur help...