Hi Gary,
have you tried something like this:
{=SUM(IF(B2:B10<=C2:C10;1;0))}
for example, according to
https://ask.libreoffice.org/en/question/20404/how-do-i-make-an-array-formula-out-of-a-function-that-normally-takes-array-arguments/
the max()/min() functions do not work this way.
Regards
Oliver
Am 14.08.2018 um 17:23 schrieb Gary Aitken:
I'm having trouble getting an array expression to work in calc.
What I want is this:
{ COUNT( (MIN(B2:B10; C2:C10) = B2:B10) ) }
That is, count the number of rows in which the minimum across columns
B and C is in column B.
The expression
MIN(B3; C3) = B3
works fine when entered in an individual row...
Any help would be much appreciated.
I do know to use <ctrl><shift><enter>
Thanks,
Gary
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
