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]
