Arrays and Averages

W

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
 
S

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:
 
W

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.

Stefi said:
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
 
W

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 =D5:D10*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(A1:D1) is better than {=AVERAGE(A1:D1)} so
if they're the only options then my question was flawed, sorry.

Thanks,

Wendy

Shane Devenshire said:
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 said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top