easy excel question

**ness80** · 01-22-2007, 03:15 AM

Dear all:

I have an easy question.

I am simply wanting to average values that are in non-contiguous rows or columns. However, when I finish selecting all the cells I want to average, excel comes up with an error - I am assuming that it is because I am wanting to average more than 30 values or arguments. Would this be correct? If so, is there a way that I can select more than 30 arguments?

I am sure this is a simple matter.

Thanks in advance,

Vanessa

**VBA Noob** · 01-22-2007, 03:32 AM

Hi,

You can use another set of parentheses within AVERAGE to get around the limit of 30 arguments.

For example:

=AVERAGE
((A2,A4,A6,A8,A10,A12,A14,A16,A18,A20,A22,A24,A26,A28,A30,
A32,A34,A36,A38,A41,A43,A45,A47,A49,A51,A53,A55,A57,A59),A
61,A63,A65,A67,A69,A71,A73,A75,A77,A80,A82,A84)

Notice how the A2 to A59 are enclosed in ( ).

VBA Noob