Arrays and Averages

[Wendy-Bob]

Hi there,

I'm trying to do an array but my knowledge of them is extremely basic and
I'm struggling.

This is my data:

C D E F

5 10 10 10
6 10 10 10
7 8 7 7
8 10 10 10
9 10 8 8
10 10 10 10

I need an array for F5:F10 that averages each row individually
(so, F5 = 10, F7 = 7, and so on)

The simpler you can make it [read as: the easier for me to understand] the
better.

Any help would be greatly appreciated.

Thanks,

Wendy

 

[Stefi]

Maybe I don't understand you exactly, but the desired averages in cells
F5:F10 can be achieved with
=AVERAGE(C5:E5)
in F5 and filled down to F10.

Regards,
Stefi

„Wendy-Bob†ezt írta:

 

[Wendy-Bob]

Sorry Stefi, I know how to do a regular formula for it, I am just trying to
figure out whether there's an array formula I can use instead. The
spreadsheet is much bigger than the cells I have quoted.

Thanks for your help though.

Maybe I don't understand you exactly, but the desired averages in cells
F5:F10 can be achieved with
=AVERAGE(C5:E5)
in F5 and filled down to F10.

Regards,
Stefi

„Wendy-Bob†ezt írta:

Hi there,

I'm trying to do an array but my knowledge of them is extremely basic and
I'm struggling.

This is my data:

C D E F

5 10 10 10
6 10 10 10
7 8 7 7
8 10 10 10
9 10 8 8
10 10 10 10

I need an array for F5:F10 that averages each row individually
(so, F5 = 10, F7 = 7, and so on)

The simpler you can make it [read as: the easier for me to understand] the
better.

Any help would be greatly appreciated.

Thanks,

Wendy

 

[Wendy-Bob]

I think I'm just misunderstanding the functionality.

I can run an array formula to work out an individual sum for each row of
data. using my data as an example, I can put the array formula =D510*E5:E10
in cells F5:F10 and it works all the calculations out for me at once.

I thought that there might be a similar average formula that could do the
same. ie one array function that could effectively negate the need for 10000
plain AVERAGE functions. But it sounds as though there isn't and I've
misunderstood what you can and can't do with arrays.

I absolutely agree that =AVERAGE(A11) is better than {=AVERAGE(A11)} so
if they're the only options then my question was flawed, sorry.

Thanks,

Wendy

Hi,

Do you want the average on each row or are you trying to do something with
all the averages in one cell? Suppose you have 10000 rows of data.
Constructing 10000 array formulas, one for each row, would gain you nothing
over using 10000 regular AVERAGE functions, in fact the arrays would probably
run slower, and use more memory than the same number of just plain AVERAGE
functions.

For example =AVERAGE(A11) is better than {=AVERAGE(A11)}.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

Sorry Stefi, I know how to do a regular formula for it, I am just trying to
figure out whether there's an array formula I can use instead. The
spreadsheet is much bigger than the cells I have quoted.

Thanks for your help though.

Maybe I don't understand you exactly, but the desired averages in cells
F5:F10 can be achieved with
=AVERAGE(C5:E5)
in F5 and filled down to F10.

Regards,
Stefi

„Wendy-Bob†ezt írta:

Hi there,

I'm trying to do an array but my knowledge of them is extremely basic and
I'm struggling.

This is my data:

C D E F

5 10 10 10
6 10 10 10
7 8 7 7
8 10 10 10
9 10 8 8
10 10 10 10

I need an array for F5:F10 that averages each row individually
(so, F5 = 10, F7 = 7, and so on)

The simpler you can make it [read as: the easier for me to understand] the
better.

Any help would be greatly appreciated.

Thanks,

Wendy