the two main categories are "FP"(for profit) and "NP"(non profit). One column
is devoted to distinguishing between the two for each application. Is there a
way to pull data from cells that only sit in the same row as an "FP" or "NP" ?


"Ron Coderre" wrote:

Perhaps there's a particular pattern associated with the cells you want to
average.
Example:
.. A word (eg "Total") in a cell to the side of it? or one cell up and to the
left?

Have anything like that?

--------------------------

Regards,

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


"pjr" wrote in message
...
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?