Help with array formula

[GastonFranzini]

I need help with an array formula,
I have to columns, I need to find the min, the max and average form the
two columns added, but I cant create a new column.
E.g.;

name s1 s2
John 1 1
Peter 3 5
Frank 6 3

min= 2 ( John)
Max= 9 (Frank)
average= 6.33

Thanks

 

[JE McGimpsey]

One way (array entered):

=MIN(B2:B4+C2:C4)

=MAX(B2:B4+C2:C4)

=AVERAGE(B2:B4+C2:C4)

 

[GastonFranzini]

Thanks!

 

[Don Guillett]

try this idea
=SUMPRODUCT(MAX((I2:I4)+(J2:J4)))
isn't the average 7.33

 

[Sandy Mann]

isn't the average 7.33

How do you get that? If I substitute AVERAGE for MAX in you formula I get
6.3333333 the same as if I sum the values in a different calumn and then
average that.

--
Regards,


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Don Guillett]

I was using a different set of numbers.