At 16:33 11/11/2008 -0500, Joe Smith wrote:
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!
Oh, but not nearly as nicely done as by you, it transpires!
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.
Nothing minor about it: yours is a much neater solution. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
