Re: complex vector sum, sumproduct, et cetera

From: Morten Welinder <mortenw gnome org>
To: John Denker <jsd av8n com>
Cc: Gnumeric Spreadsheet List <gnumeric-list gnome org>
Subject: Re: complex vector sum, sumproduct, et cetera
Date: Mon, 8 Apr 2013 15:37:40 -0400

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.

References:
- complex vector sum, sumproduct, et cetera
  - From: John Denker

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