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.
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
