On Mon, 10 Nov 2008 15:24:19 +0000 Came this utterance fomulated by Graham Smith to my mailbox:
> 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. > I'd look at an extra hidden row somewhere below row 2. Say it is row 11 Then you could have c11 = c2*(c2-1), d11 = d2*(d2-1) etc. Then your formula becomes SUM(c11:g11)/(SUM(c2:g2)*(SUM(c2:g2)-1)). It seems unusual to me that your repeating rows go across rather than down. The spreadsheet has more room down than across. You may be limited to 256 columns wide. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
