Brian Barker wrote:
... 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))
...
Nicely done!
Just one pointless point: The numerator
SUM(C2:G2*(C2:G2-1))
is equivalent to
SUMPRODUCT(C2:G2;C2:G2-1)
in which case you don't need the (minor) bother of an array formula.
I don't know if there is any performance difference, but you might find
one or the other is faster, once you scale up to many cells.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
