View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
pjr pjr is offline
external usenet poster
 
Posts: 10
Default How can I place more than 30 arguments in an average function?

Sorry for not being more specific. The arguments are not evenly spaced. I'm
making a spreadsheet for the results of an application process. the
applications are listed in order, 1 thru 126, but the formula that I am
making is based on information that shows up throughout the list, independant
of their application number.

"Ron Coderre" wrote:

If the arguments are evenly spaced (eg every 3rd cell...A1, A4, A7, etc),
let us know.
There may be options that will increment the cell references automatically.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"pjr" wrote in message
...
Is it possible to have more than thirty arguments in a single average
function? The arguments are not contiguous, so i can't just make them into
data points...

What should I do?