Help with array formula

G

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
 
J

JE McGimpsey

One way (array entered):

=MIN(B2:B4+C2:C4)

=MAX(B2:B4+C2:C4)

=AVERAGE(B2:B4+C2:C4)
 
S

Sandy Mann

Don Guillett said:
isn't the average 7.33
Click to expand...

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top