At 11:53 23/03/2008 +0100, Juergen Diel wrote:
[...]
And, it seems to be not possible to do a sumproduct of a horizontal
and vertical [vector]. =SUMPRODUCT(A12:A14;A1:C1) returns a #Value error.
There is a workaround for this:
=SUMPRODUCT(A12:A14;TRANSPOSE(A1:C1))
appears to work. But perhaps you knew that ...
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
