Arrays and Averages
 

I still don't understand! What do you want to achieve with an array formula
what is more then the result of the regular formulae?

Stefi

€žWendy-Bob€� ezt Ã*rta:

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.

"Stefi" wrote:

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

Arrays and Averages
 

Don't worry about it, I obviously don't get it or am misunderstanding
something. Thanks for your help. I'll just use a regular average formula.

"Stefi" wrote:

I still don't understand! What do you want to achieve with an array formula
what is more then the result of the regular formulae?

Stefi

€žWendy-Bob€� ezt Ã*rta:

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.

"Stefi" wrote:

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