PDA

View Full Version : MAX and MIM problem in Arrays



makako
03-01-2010, 10:45 AM
Hi, Im using some arrays and I need to generate de min value of each array: Im using {=SUM(MIN(ARRAY1,ARRAY2))} But instead of having the sum of the minimum values Im getting the minimum value of both arrays. Example
Arr1 (1,5,6,2) Arr2 (2,5,2,6) I Need SUM(Arr3 (1,5,2,2)) = 10 but Im getting SUM(Min(((1,5,6,2) , (2,5,2,6))), = sum(min(1,5,6,2,2,5,2,6)), = sum(1) = 1.
Any Ideas?

Bob Phillips
03-01-2010, 11:26 AM
Try this array formula

=SUM(IF(ARRAY1<ARRAY2,ARRAY1,ARRAY2))