If yoare willing to use an extra row you can simplify the top
enormously. In row 2 we have C2, D2, E2,....
in row 3,columnC put "=C2*(C2-1). copy and paste this across the row
(as far as column G in the example. Then the numerator can be
evaluated simply as sum(c3:g3).
The denominator is simple enough as it is.
On Nov 10, 2008, at 10:24, Graham Smith wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
