Brian
> When you say a couple of hundred cells, it is not clear whether you mean
> rows or columns. If you need this formula to apply to columns C to G but
> for many rows, you can simply copy it down a column, of course. But perhaps
> you mean that you need to expand the formula to deal with not five columns
> but many more. If so, you can do this using an array formula. Enter this
> into your result cell:
> =SUM(C2:G2*(C2:G2-1))/(SUM(C2:G2)*(SUM(C2:G2)-1))
> but instead of pressing Enter to complete the entry, press Ctrl+Shift+Enter.
> The complete formula will now appear in the Input Line preceded and
> followed by braces:
> {=SUM(C2:G2*(C2:G2-1))/(SUM(C2:G2)*(SUM(C2:G2)-1))}
> but note that you *cannot* achieve the same effect by typing the braces
> yourself. This produces the same effect as the original formula. But with
> this version, you can easily extend the formula by changing the limits C and
> G without complicating the expression, of course.
This looks excellent, I have a nearly 200 columns and 800 plus rows,
so the latter suggestion looks the sort of thing I was hoping for.
Many thanks,
Graham
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
