Selecting more than 30 in a formula

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
 
A

Alex

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
 
E

Earl Kiosterud

Sammi,

Use a single range argument.

=AVERAGE(A1:A65536)

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

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

Similar Threads

How to create a bubble chart with more than 2 variables. 0
How can the font and size of (all) citation numbers be altered? 1
Average more than 30 numeric arguments 15
#DIV error 2
copy specific cells from sheets if the information is correct 3
Formula to answer YES or No 4
Using the list form control: multi-selection possible? 3
MATH COMPUTAION 6

Top