Re: complex vector sum, sumproduct, et cetera



The problem here is that IMSUM and IMPRODUCT are functions that take
arbitrary number of arguments.  Such functions are not subject to implicit
iteration.

If you want to get creative, you can probably use something like

    =imsum(imdiv(imsub(A1:A5,imneg(B1:B5)),iminv(C1:C5)))

in array mode.  That work work with zeros in column C, of course.

M.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]