Michael Thanks for the response.
> 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)). I will have to think about this as I don't exactly follow what you mean. > > 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. The columns are sample variables, which is why they go across, the rows are used for the samples which the variables were measured for. There are considerably which are considerably more samples than variable (round 800 I think), and I need to do this calculation for all 800 samples. Graham --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
