I tried a small example with the 2 sheet formulation and it seems to
work In sheet 1 we have the original data in C1 to J1. In sheet 2
we have the formula "=Sheet1.C1*(Sheet1.C1-1)" copied and pasted
across the 1st row. Back in sheet 1 one gets the numerator as the
formula "=SUM(Sheet2.C1:Sheet2.J1)".
On Nov 10, 2008, at 17:59, Graham Smith wrote:
2008/11/10 Robertson Dale A. <[EMAIL PROTECTED]>:
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.
As I will have a about 800 rows of data, this probably isn't a
realistic solution in this case.
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]
