Selecting more than 30 in a formula

  • Thread starter Thread starter Sammi
  • Start date Start date
S

Sammi

I am creating a formula in XL 2002. Is there a way to be
able to select more than 30 cell references??

E.G. =Average(a1,a2,a3 All the way to any number I
want.

I heard there was a plug-in.

Please help!!

Sammi
 
Sammi

Why not use?

=AVERAGE(a1:a10000
Ale
----- Sammi wrote: ----

I am creating a formula in XL 2002. Is there a way to be
able to select more than 30 cell references?

E.G. =Average(a1,a2,a3 All the way to any number I
want

I heard there was a plug-in.

Please help!

Samm
 
Sammi,

Use a single range argument.

=AVERAGE(A1:A65536)

That's 65536 cell references, one argument. (Max 30 function arguments)
 
Back
Top