I have the following formula =SUM(C2*(C2-1)+(D2*(D2-1)+(E2*(E2-1)+(F2*(F2-1)+(G2*(G2-1))))))/(SUM(C2:G2)*((SUM(C2:G2))-1))
Where the first part is a repeating chunk of code, which may need to be repeated for a couple of hundred cells. Is there a clever way of setting this up so I only need to put the first and last cell into the formula that would tell Calc to repeat the same calculation for all the cells in between. Many thanks, Graham --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
