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(A1:D1) is better than {=AVERAGE(A1:D1)}.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Wendy-Bob" wrote:

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