Function Cell Reference Limit?

[Kevin]

Hello,

Can anyone tell me if there is a limit on the number of
cells that can be referenced in the "Average" Worksheet
function? I seem to be running into such a limit. If so,
is there a wasy around it?

Thanks in advance!

Kevin

 

[AP]

The limit is 30 arguments. You can try and calculate the
average yourself:

=Sum("datarange")/Counta("datarange")

AP

 

[Jason Morin]

Your limit is 30 arguments. Try your best to group cells
into ranges which will extend your formula, such as:

=AVERAGE(A1:A3,B5:B6,...)

rather than

=AVERAGE(A1,A2,A3,B5,B6,...)

If you really have more than 30 non-contiguous cells to
average, one way is to enclose 29 arguments within another
set of () and keep adding on. For example:

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

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

HTH
Jason
Atlanta, GA

 

[Kevin]

To both of you, Thanks! That helped!