Thread
:
minimum along rows
View Single Post
#
1
[email protected]
Posts: n/a
minimum along rows
Hi,
Is it possible to sum up the minimums of each row in one line commmand?
E.g.
A B
1 5 6
2 2 0
3 1 3
Ans: 5 + 0 + 1
I've tried
{=sum(min(a1:a3,b1:b3))}
but it doesn't work.
Thanks
Reply With Quote